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.PAY_ASSG_COST_SS dependencies on HR_TRANSACTION_SS

Line 58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;

54:
55: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
56: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
57: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
58: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
59: l_count NUMBER;
60: l_result VARCHAR2(100);
61: L_EFFECTIVE_DATE DATE;
62: BEGIN

Line 65: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);

61: L_EFFECTIVE_DATE DATE;
62: BEGIN
63: IF g_debug THEN
64: hr_utility.set_location('Entering '||l_proc, 10);
65: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);
66: END IF;
67:
68: IF P_EFFECTIVE_DATE IS NULL THEN
69: L_EFFECTIVE_DATE := SYSDATE;

Line 73: hr_transaction_ss.create_transaction_step(

69: L_EFFECTIVE_DATE := SYSDATE;
70: ELSE
71: L_EFFECTIVE_DATE := P_EFFECTIVE_DATE;
72: END IF;
73: hr_transaction_ss.create_transaction_step(
74: p_item_type => p_item_type
75: ,p_item_key => p_item_key
76: ,p_actid => 0 --p_actid
77: ,p_login_person_id => p_login_person_id

Line 81: l_transaction_id:= hr_transaction_ss.get_transaction_id

77: ,p_login_person_id => p_login_person_id
78: ,p_api_name => g_package||'CREATE_DATA'
79: ,p_transaction_step_id => l_transaction_step_id
80: ,p_object_version_number => l_trs_object_version_number);
81: l_transaction_id:= hr_transaction_ss.get_transaction_id
82: (p_item_type => p_item_type
83: ,p_item_key => p_item_key);
84: IF g_debug THEN
85: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 110);

Line 85: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 110);

81: l_transaction_id:= hr_transaction_ss.get_transaction_id
82: (p_item_type => p_item_type
83: ,p_item_key => p_item_key);
84: IF g_debug THEN
85: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 110);
86: END IF;
87:
88: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with
89: the user specified values. This data will be used to populate the trasaction

Line 88: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with

84: IF g_debug THEN
85: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 110);
86: END IF;
87:
88: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with
89: the user specified values. This data will be used to populate the trasaction
90: tables and subsequently into the base tables once approved.*/
91: --
92: --TRANSACTION_ID

Line 117: hr_transaction_ss.g_date_format);

113: --
114: l_count := l_count + 1;
115: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
116: l_transaction_table(l_count).param_value := to_char(L_effective_date,
117: hr_transaction_ss.g_date_format);
118: l_transaction_table(l_count).param_data_type := 'DATE';
119: --
120: l_count := l_count + 1;
121: l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';

Line 311: hr_transaction_ss.g_date_format);

307: if P_EFFECTIVE_START_DATE IS NULL THEN
308: l_transaction_table(l_count).param_value := NULL;
309: else
310: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_START_DATE,
311: hr_transaction_ss.g_date_format);
312: end if;
313: l_transaction_table(l_count).param_data_type := 'DATE';
314: --
315: l_count := l_count + 1;

Line 321: hr_transaction_ss.g_date_format);

317: if P_EFFECTIVE_END_DATE IS NULL THEN
318: l_transaction_table(l_count).param_value := NULL;
319: else
320: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_END_DATE,
321: hr_transaction_ss.g_date_format);
322: end if;
323: l_transaction_table(l_count).param_data_type := 'DATE';
324: --
325: IF g_debug THEN

Line 326: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 120);

322: end if;
323: l_transaction_table(l_count).param_data_type := 'DATE';
324: --
325: IF g_debug THEN
326: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 120);
327: END IF;
328: /*Save data into transaction tables*/
329: hr_transaction_ss.save_transaction_step
330: (p_item_type => p_item_type

Line 329: hr_transaction_ss.save_transaction_step

325: IF g_debug THEN
326: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 120);
327: END IF;
328: /*Save data into transaction tables*/
329: hr_transaction_ss.save_transaction_step
330: (p_item_type => p_item_type
331: ,p_item_key => p_item_key
332: ,p_actid => 0 --p_actid
333: ,p_login_person_id => p_login_person_id

Line 338: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 130);

334: ,p_transaction_step_id => l_transaction_step_id
335: ,p_api_name => g_package || 'CREATE_DATA'
336: ,p_transaction_data => l_transaction_table);
337: IF g_debug THEN
338: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 130);
339: hr_utility.set_location('Leaving '||l_proc, 1000);
340: END IF;
341: p_transaction_id := l_transaction_id;
342: p_transaction_step_id := l_transaction_step_id;

Line 583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;

579:
580: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
581: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
582: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
583: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
584: l_count NUMBER;
585: l_effective_date date;
586: l_result varchar2(2000);
587: BEGIN

Line 597: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);

593: else
594: l_EFFECTIVE_DATE := P_EFFECTIVE_DATE;
595: END IF;
596: IF g_debug THEN
597: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);
598: END IF;
599: /*This CREATE_TRANSACTION_STEP() find out of any transaction created with
600: the given ITEM TYPE and ITEM KEY. If exists then it creates transaction
601: step if not it creates a transactions and transaction step as well.*/

Line 602: hr_transaction_ss.create_transaction_step(

598: END IF;
599: /*This CREATE_TRANSACTION_STEP() find out of any transaction created with
600: the given ITEM TYPE and ITEM KEY. If exists then it creates transaction
601: step if not it creates a transactions and transaction step as well.*/
602: hr_transaction_ss.create_transaction_step(
603: p_item_type => p_item_type
604: ,p_item_key => p_item_key
605: ,p_actid => 0 --p_actid
606: ,p_login_person_id => p_login_person_id

Line 611: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 100);

607: ,p_api_name => g_package||'UPDATE_DATA'
608: ,p_transaction_step_id => l_transaction_step_id
609: ,p_object_version_number => l_trs_object_version_number);
610: IF g_debug THEN
611: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 100);
612: END IF;
613: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with
614: the user specified values. This data will be used to populate the trasaction
615: tables and subsequently into the base tables.

Line 613: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with

609: ,p_object_version_number => l_trs_object_version_number);
610: IF g_debug THEN
611: hr_utility.set_location('Populating the user defined table structure hr_transaction_ss.transaction_table', 100);
612: END IF;
613: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with
614: the user specified values. This data will be used to populate the trasaction
615: tables and subsequently into the base tables.
616: */
617: l_count := 1;

Line 646: hr_transaction_ss.g_date_format);

642: --
643: l_count := l_count + 1;
644: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
645: l_transaction_table(l_count).param_value := to_char(l_effective_date,
646: hr_transaction_ss.g_date_format);
647: l_transaction_table(l_count).param_data_type := 'DATE';
648: --
649: l_count := l_count + 1;
650: l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';

Line 840: hr_transaction_ss.g_date_format);

836: if P_EFFECTIVE_START_DATE IS NULL THEN
837: l_transaction_table(l_count).param_value := NULL;
838: else
839: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_START_DATE,
840: hr_transaction_ss.g_date_format);
841: end if;
842: l_transaction_table(l_count).param_data_type := 'DATE';
843: --
844: l_count := l_count + 1;

Line 850: hr_transaction_ss.g_date_format);

846: if P_EFFECTIVE_END_DATE IS NULL THEN
847: l_transaction_table(l_count).param_value := NULL;
848: else
849: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_END_DATE,
850: hr_transaction_ss.g_date_format);
851: end if;
852: l_transaction_table(l_count).param_data_type := 'DATE';
853: --
854: /*Save data into transaction tables*/

Line 856: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);

852: l_transaction_table(l_count).param_data_type := 'DATE';
853: --
854: /*Save data into transaction tables*/
855: if g_debug then
856: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);
857: end if;
858: hr_transaction_ss.save_transaction_step
859: (p_item_type => p_item_type
860: ,p_item_key => p_item_key

Line 858: hr_transaction_ss.save_transaction_step

854: /*Save data into transaction tables*/
855: if g_debug then
856: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);
857: end if;
858: hr_transaction_ss.save_transaction_step
859: (p_item_type => p_item_type
860: ,p_item_key => p_item_key
861: ,p_actid => 0 --p_actid
862: ,p_login_person_id => p_login_person_id

Line 869: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);

865: ,p_transaction_data => l_transaction_table);
866: p_transaction_id := l_transaction_id;
867: p_transaction_step_id := l_transaction_step_id;
868: if g_debug then
869: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);
870: hr_utility.set_location('Leaving '||l_proc,1000);
871: end if;
872: END UPDATE_ASSG_COST;
873:

Line 1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;

1074:
1075: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
1076: l_transaction_step_id HR_API_TRANSACTION_STEPS.TRANSACTION_STEP_ID%TYPE;
1077: l_trs_object_version_number HR_API_TRANSACTION_STEPS.OBJECT_VERSION_NUMBER%TYPE;
1078: l_transaction_table HR_TRANSACTION_SS.TRANSACTION_TABLE;
1079: l_count NUMBER;
1080: l_result VARCHAR2(100);
1081: L_EFFECTIVE_DATE DATE;
1082: BEGIN

Line 1085: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);

1081: L_EFFECTIVE_DATE DATE;
1082: BEGIN
1083: IF g_debug THEN
1084: hr_utility.set_location('Entering '||l_proc, 10);
1085: hr_utility.set_location('Calling hr_transaction_ss.create_transaction_step', 100);
1086: END IF;
1087:
1088: IF P_EFFECTIVE_DATE IS NULL THEN
1089: L_EFFECTIVE_DATE := SYSDATE;

Line 1098: hr_transaction_ss.create_transaction_step(

1094: /*This CREATE_TRANSACTION_STEP() find out of any transaction created with
1095: the given ITEM TYPE and ITEM KEY. If exists then it creates transaction
1096: step if not it creates a transactions and transaction step as well.*/
1097:
1098: hr_transaction_ss.create_transaction_step(
1099: p_item_type => p_item_type
1100: ,p_item_key => p_item_key
1101: ,p_actid => 0 --p_actid
1102: ,p_login_person_id => p_login_person_id

Line 1107: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 130);

1103: ,p_api_name => g_package||'DELETE_DATA'
1104: ,p_transaction_step_id => l_transaction_step_id
1105: ,p_object_version_number => l_trs_object_version_number);
1106: IF g_debug THEN
1107: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 130);
1108: hr_utility.set_location('Leaving '||l_proc, 1000);
1109: END IF;
1110:
1111: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with

Line 1111: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with

1107: hr_utility.set_location('After Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 130);
1108: hr_utility.set_location('Leaving '||l_proc, 1000);
1109: END IF;
1110:
1111: /*Populating the table structure HR_TRANSACTION_SS.TRANSACTION_TABLE with
1112: the user specified values. This data will be used to populate the trasaction
1113: tables and subsequently into the base tables.
1114: */
1115: l_count := 1;

Line 1144: hr_transaction_ss.g_date_format);

1140: --
1141: l_count := l_count + 1;
1142: l_transaction_table(l_count).param_name := 'P_EFFECTIVE_DATE';
1143: l_transaction_table(l_count).param_value := to_char(l_effective_date,
1144: hr_transaction_ss.g_date_format);
1145: l_transaction_table(l_count).param_data_type := 'DATE';
1146: --
1147: l_count := l_count + 1;
1148: l_transaction_table(l_count).param_name := 'P_OBJECT_VERSION_NUMBER';

Line 1173: hr_transaction_ss.g_date_format);

1169: if P_EFFECTIVE_START_DATE IS NULL THEN
1170: l_transaction_table(l_count).param_value := NULL;
1171: else
1172: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_START_DATE,
1173: hr_transaction_ss.g_date_format);
1174: end if;
1175: l_transaction_table(l_count).param_data_type := 'DATE';
1176: --
1177: l_count := l_count + 1;

Line 1183: hr_transaction_ss.g_date_format);

1179: if P_EFFECTIVE_END_DATE IS NULL THEN
1180: l_transaction_table(l_count).param_value := NULL;
1181: else
1182: l_transaction_table(l_count).param_value := to_char(P_EFFECTIVE_END_DATE,
1183: hr_transaction_ss.g_date_format);
1184: end if;
1185: l_transaction_table(l_count).param_data_type := 'DATE';
1186: /*Save data into transaction tables*/
1187: if g_debug then

Line 1188: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);

1184: end if;
1185: l_transaction_table(l_count).param_data_type := 'DATE';
1186: /*Save data into transaction tables*/
1187: if g_debug then
1188: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);
1189: end if;
1190: hr_transaction_ss.save_transaction_step
1191: (p_item_type => p_item_type
1192: ,p_item_key => p_item_key

Line 1190: hr_transaction_ss.save_transaction_step

1186: /*Save data into transaction tables*/
1187: if g_debug then
1188: hr_utility.set_location('Calling HR_TRANSACTION_SS.SAVE_TRANSACTION_STEP', 110);
1189: end if;
1190: hr_transaction_ss.save_transaction_step
1191: (p_item_type => p_item_type
1192: ,p_item_key => p_item_key
1193: ,p_actid => 0 --p_actid
1194: ,p_login_person_id => p_login_person_id