eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_WIP_TXNS dependencies on HR_WIP_TRANSACTIONS_S

Line 171: (p_state IN hr_wip_transactions.state%TYPE

167: -- ----------------------------------------------------------------------------
168: -- |-----------------------< chk_state >-------------------------------|
169: -- ----------------------------------------------------------------------------
170: Procedure chk_state
171: (p_state IN hr_wip_transactions.state%TYPE
172: )is
173: begin
174: If p_state not in (g_start_state,g_save_for_later_state
175: ,g_pending_approval_state,g_reject_for_correction_state)

Line 186: (p_state IN hr_wip_transactions.state%TYPE

182: -- ----------------------------------------------------------------------------
183: -- |-----------------------< chk_sub_state >-----------------------|
184: -- ----------------------------------------------------------------------------
185: Procedure chk_sub_state
186: (p_state IN hr_wip_transactions.state%TYPE
187: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE)is
188: begin
189: If (p_state <> g_save_for_later_state and p_sub_state is not null)
190: then

Line 187: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE)is

183: -- |-----------------------< chk_sub_state >-----------------------|
184: -- ----------------------------------------------------------------------------
185: Procedure chk_sub_state
186: (p_state IN hr_wip_transactions.state%TYPE
187: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE)is
188: begin
189: If (p_state <> g_save_for_later_state and p_sub_state is not null)
190: then
191: fnd_message.set_name('PER','PER_289668_TXN_INV_SUBSTATE');

Line 294: values(hr_wip_transactions_s.nextval

290: ,vo_cache
291: ,context_display_text
292: ,dml_mode
293: )
294: values(hr_wip_transactions_s.nextval
295: ,p_creator_user_id
296: ,p_item_type
297: ,p_item_key
298: ,p_function_id

Line 319: ,p_state IN hr_wip_transactions.state%TYPE

315: -- |-----------------------< upd >-----------------------|
316: -- ----------------------------------------------------------------------------
317: Procedure upd
318: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
319: ,p_state IN hr_wip_transactions.state%TYPE
320: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
321: ,p_vo_xml IN VARCHAR2
322: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
323: default hr_api.g_varchar2

Line 320: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

316: -- ----------------------------------------------------------------------------
317: Procedure upd
318: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
319: ,p_state IN hr_wip_transactions.state%TYPE
320: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
321: ,p_vo_xml IN VARCHAR2
322: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
323: default hr_api.g_varchar2
324: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE

Line 455: ,p_state IN hr_wip_transactions.state%TYPE

451: Procedure save_for_later
452: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
453: ,p_current_user_id IN hr_wip_transactions.creator_user_id%TYPE
454: ,p_creator_user_id IN hr_wip_transactions.creator_user_id%TYPE
455: ,p_state IN hr_wip_transactions.state%TYPE
456: ,p_vo_xml IN VARCHAR2
457: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
458: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
459: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is

Line 457: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

453: ,p_current_user_id IN hr_wip_transactions.creator_user_id%TYPE
454: ,p_creator_user_id IN hr_wip_transactions.creator_user_id%TYPE
455: ,p_state IN hr_wip_transactions.state%TYPE
456: ,p_vo_xml IN VARCHAR2
457: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
458: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
459: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is
460: --
461: begin

Line 493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

489: (p_item_type IN wf_items.item_type%TYPE
490: ,p_item_key IN wf_items.item_key%TYPE
491: ,p_current_user_id IN fnd_user.user_id%TYPE
492: ,p_vo_xml IN VARCHAR2
493: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
494: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
495: default hr_api.g_varchar2
496: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
497: default hr_api.g_varchar2

Line 502: l_state hr_wip_transactions.state%TYPE;

498: ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
499: )is
500: PRAGMA AUTONOMOUS_TRANSACTION;
501: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
502: l_state hr_wip_transactions.state%TYPE;
503: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
504: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
505: cursor csr_user_id is
506: select creator_user_id

Line 566: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

562: Procedure save_for_later
563: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
564: ,p_current_user_id IN fnd_user.user_id%TYPE
565: ,p_vo_xml IN VARCHAR2
566: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
567: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
568: default hr_api.g_varchar2
569: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
570: default hr_api.g_varchar2

Line 574: l_state hr_wip_transactions.state%TYPE;

570: default hr_api.g_varchar2
571: )is
572: PRAGMA AUTONOMOUS_TRANSACTION;
573: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
574: l_state hr_wip_transactions.state%TYPE;
575: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
576: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
577: cursor csr_user_id is
578: select creator_user_id,

Line 671: ,p_state IN hr_wip_transactions.state%TYPE

667: Procedure pending_approval
668: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
669: ,p_current_user_id IN hr_wip_transactions.creator_user_id%TYPE
670: ,p_creator_user_id IN hr_wip_transactions.creator_user_id%TYPE
671: ,p_state IN hr_wip_transactions.state%TYPE
672: ,p_vo_xml IN VARCHAR2
673: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
674: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
675: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is

Line 673: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

669: ,p_current_user_id IN hr_wip_transactions.creator_user_id%TYPE
670: ,p_creator_user_id IN hr_wip_transactions.creator_user_id%TYPE
671: ,p_state IN hr_wip_transactions.state%TYPE
672: ,p_vo_xml IN VARCHAR2
673: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
674: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
675: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is
676: begin
677: chk_transaction_creator(p_creator_user_id => p_creator_user_id

Line 719: l_state hr_wip_transactions.state%TYPE;

715: )is
716: PRAGMA AUTONOMOUS_TRANSACTION;
717: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
718: l_transaction_id hr_wip_transactions.transaction_id%TYPE;
719: l_state hr_wip_transactions.state%TYPE;
720: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
721: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
722: cursor csr_user_id is
723: select creator_user_id,

Line 790: l_state hr_wip_transactions.state%TYPE;

786: default hr_api.g_varchar2
787: )is
788: PRAGMA AUTONOMOUS_TRANSACTION;
789: l_creator_user_id hr_wip_transactions.creator_user_id%TYPE;
790: l_state hr_wip_transactions.state%TYPE;
791: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
792: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
793: cursor csr_user_id is
794: select creator_user_id,

Line 843: ,p_state IN hr_wip_transactions.state%TYPE

839: -- |-----------------------< reject_for_correction >-----------------------|
840: -- ----------------------------------------------------------------------------
841: Procedure reject_for_correction
842: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
843: ,p_state IN hr_wip_transactions.state%TYPE
844: ,p_vo_xml IN clob
845: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
846: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
847: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is

Line 845: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

841: Procedure reject_for_correction
842: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
843: ,p_state IN hr_wip_transactions.state%TYPE
844: ,p_vo_xml IN clob
845: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
846: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
847: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE) is
848: l_vo_xml_var varchar(32767);
849: l_amount number;

Line 879: l_state hr_wip_transactions.state%TYPE;

875: (p_item_type IN wf_items.item_type%TYPE
876: ,p_item_key IN wf_items.item_key%TYPE
877: )is
878: PRAGMA AUTONOMOUS_TRANSACTION;
879: l_state hr_wip_transactions.state%TYPE;
880: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
881: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
882: l_transaction_id hr_wip_transactions.transaction_id%TYPE;
883: l_vo_xml clob;

Line 936: l_state hr_wip_transactions.state%TYPE;

932: Procedure reject_for_correction
933: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
934: )is
935: PRAGMA AUTONOMOUS_TRANSACTION;
936: l_state hr_wip_transactions.state%TYPE;
937: l_dml_mode hr_wip_transactions.dml_mode%TYPE;
938: l_context_display_text hr_wip_transactions.context_display_text%TYPE;
939: l_vo_xml clob;
940: cursor csr_user_id is

Line 1069: ,p_state IN hr_wip_transactions.state%TYPE

1065: -- ----------------------------------------------------------------------------
1066: Procedure update_transaction
1067: (p_item_type IN wf_items.item_type%TYPE
1068: ,p_item_key IN wf_items.item_key%TYPE
1069: ,p_state IN hr_wip_transactions.state%TYPE
1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1072: default hr_api.g_varchar2
1073: ,p_vo_xml IN VARCHAR2

Line 1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

1066: Procedure update_transaction
1067: (p_item_type IN wf_items.item_type%TYPE
1068: ,p_item_key IN wf_items.item_key%TYPE
1069: ,p_state IN hr_wip_transactions.state%TYPE
1070: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1071: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1072: default hr_api.g_varchar2
1073: ,p_vo_xml IN VARCHAR2
1074: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE

Line 1141: ,p_state IN hr_wip_transactions.state%TYPE

1137: -- |-----------------------< update_transaction >-----------------------|
1138: -- ----------------------------------------------------------------------------
1139: Procedure update_transaction
1140: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
1141: ,p_state IN hr_wip_transactions.state%TYPE
1142: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1143: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1144: default hr_api.g_varchar2
1145: ,p_vo_xml IN VARCHAR2

Line 1142: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE

1138: -- ----------------------------------------------------------------------------
1139: Procedure update_transaction
1140: (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
1141: ,p_state IN hr_wip_transactions.state%TYPE
1142: ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
1143: ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
1144: default hr_api.g_varchar2
1145: ,p_vo_xml IN VARCHAR2
1146: ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE