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_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_ARCHIVE_ITEMS

Line 1100: ,p_value1 IN ff_archive_items.value%TYPE

1096: */
1097:
1098: FUNCTION compare_user_entity_value
1099: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
1100: ,p_value1 IN ff_archive_items.value%TYPE
1101: ,p_value2 IN ff_archive_items.value%TYPE
1102: ,p_data_type IN ff_database_items.data_type%TYPE)
1103: RETURN VARCHAR2
1104: IS

Line 1101: ,p_value2 IN ff_archive_items.value%TYPE

1097:
1098: FUNCTION compare_user_entity_value
1099: (p_user_entity_name IN ff_user_entities.user_entity_name%TYPE
1100: ,p_value1 IN ff_archive_items.value%TYPE
1101: ,p_value2 IN ff_archive_items.value%TYPE
1102: ,p_data_type IN ff_database_items.data_type%TYPE)
1103: RETURN VARCHAR2
1104: IS
1105:

Line 1177: FROM ff_archive_items fae,

1173: CURSOR get_archived_user_entities
1174: (c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE)
1175: IS
1176: SELECT fue.user_entity_name
1177: FROM ff_archive_items fae,
1178: ff_user_entities fue
1179: WHERE fae.context1 = c_archive_action_id
1180: AND fue.user_entity_id = fae.user_entity_id
1181: AND (

Line 1327: FROM ff_archive_items fai,

1323: c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1324: IS
1325: SELECT fai.value
1326: ,fdi.data_type
1327: FROM ff_archive_items fai,
1328: ff_user_entities fue,
1329: ff_database_items fdi
1330: WHERE fai.context1 = c_assignment_action_id
1331: AND fai.user_entity_id = fue.user_entity_id

Line 1339: l_old_value ff_archive_items.value%TYPE;

1335: i_index NUMBER;
1336: l_procedure VARCHAR2(80);
1337:
1338: l_item_type VARCHAR2(20);
1339: l_old_value ff_archive_items.value%TYPE;
1340: l_data_type ff_database_items.data_type%TYPE;
1341:
1342: l_compare_flag VARCHAR2(2);
1343: l_etp_cmn_flag VARCHAR2(2);

Line 1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;

1350: ff_database_items fdi
1351: WHERE fdi.user_entity_id = fue.user_entity_id
1352: AND fue.user_entity_name = c_user_entity_name;
1353:
1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;
1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;

Line 1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;

1351: WHERE fdi.user_entity_id = fue.user_entity_id
1352: AND fue.user_entity_name = c_user_entity_name;
1353:
1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;
1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;

Line 1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;

1352: AND fue.user_entity_name = c_user_entity_name;
1353:
1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;
1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;

Line 1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;

1353:
1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;
1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;

Line 1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;

1354: l_payg_new_sum ff_archive_items.value%TYPE := 0;
1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;

Line 1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;

1355: l_payg_old_sum ff_archive_items.value%TYPE := 0;
1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;
1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;

Line 1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;

1356: l_fw1_new_sum ff_archive_items.value%TYPE := 0;
1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;
1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;
1364: l_fw_payg_exists varchar2(1);

Line 1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;

1357: l_fw1_old_sum ff_archive_items.value%TYPE :=0;
1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;
1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;
1364: l_fw_payg_exists varchar2(1);
1365: l_counter number;

Line 1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;

1358: l_fw1_new_sub_sum ff_archive_items.value%TYPE :=0;
1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;
1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;
1364: l_fw_payg_exists varchar2(1);
1365: l_counter number;
1366:

Line 1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;

1359: l_fw1_old_sub_sum ff_archive_items.value%TYPE :=0;
1360: l_fw2_new_sum ff_archive_items.value%TYPE := 0;
1361: l_fw2_old_sum ff_archive_items.value%TYPE :=0;
1362: l_fw2_new_sub_sum ff_archive_items.value%TYPE :=0;
1363: l_fw2_old_sub_sum ff_archive_items.value%TYPE :=0;
1364: l_fw_payg_exists varchar2(1);
1365: l_counter number;
1366:
1367: BEGIN

Line 2086: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

2082: AND fue.legislation_code = 'AU';
2083:
2084: l_procedure VARCHAR2(80);
2085: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
2086: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
2087: l_object_version_number ff_archive_items.object_version_number%type;
2088: l_some_warning boolean;
2089:
2090: e_ue_missing EXCEPTION;

Line 2087: l_object_version_number ff_archive_items.object_version_number%type;

2083:
2084: l_procedure VARCHAR2(80);
2085: l_user_entity_id ff_user_entities.user_entity_id%TYPE;
2086: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
2087: l_object_version_number ff_archive_items.object_version_number%type;
2088: l_some_warning boolean;
2089:
2090: e_ue_missing EXCEPTION;
2091:

Line 2215: FROM ff_archive_items fai,

2211: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
2212: ,c_context_id ff_contexts.context_id%TYPE)
2213: IS
2214: SELECT COUNT(*)
2215: FROM ff_archive_items fai,
2216: ff_user_entities fue,
2217: ff_archive_item_contexts faic
2218: WHERE fai.context1 = c_archive_action_id
2219: AND fue.user_entity_id = fai.user_entity_id