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.AP_ALLOCATION_RULES_PKG dependencies on FND_GLOBAL

Line 102: FND_GLOBAL.USER_ID, -- created_by

98: 'PRORATION', -- rule_type
99: 'SYSTEM', -- rule_generation_type
100: 'PENDING', -- status
101: SYSDATE, -- creation_date
102: FND_GLOBAL.USER_ID, -- created_by
103: 0, -- last_updated_by
104: SYSDATE, -- last_update_date
105: FND_GLOBAL.LOGIN_ID, -- last_update_login
106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

Line 105: FND_GLOBAL.LOGIN_ID, -- last_update_login

101: SYSDATE, -- creation_date
102: FND_GLOBAL.USER_ID, -- created_by
103: 0, -- last_updated_by
104: SYSDATE, -- last_update_date
105: FND_GLOBAL.LOGIN_ID, -- last_update_login
106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
107: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
108: SYSDATE, -- program_update_date
109: FND_GLOBAL.CONC_REQUEST_ID -- request_id

Line 106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

102: FND_GLOBAL.USER_ID, -- created_by
103: 0, -- last_updated_by
104: SYSDATE, -- last_update_date
105: FND_GLOBAL.LOGIN_ID, -- last_update_login
106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
107: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
108: SYSDATE, -- program_update_date
109: FND_GLOBAL.CONC_REQUEST_ID -- request_id
110: );

Line 107: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id

103: 0, -- last_updated_by
104: SYSDATE, -- last_update_date
105: FND_GLOBAL.LOGIN_ID, -- last_update_login
106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
107: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
108: SYSDATE, -- program_update_date
109: FND_GLOBAL.CONC_REQUEST_ID -- request_id
110: );
111: EXCEPTION

Line 109: FND_GLOBAL.CONC_REQUEST_ID -- request_id

105: FND_GLOBAL.LOGIN_ID, -- last_update_login
106: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
107: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
108: SYSDATE, -- program_update_date
109: FND_GLOBAL.CONC_REQUEST_ID -- request_id
110: );
111: EXCEPTION
112: WHEN OTHERS THEN
113: IF (SQLCODE <> -20001) THEN

Line 292: FND_GLOBAL.USER_ID, -- created_by

288: 'AMOUNT', -- rule_type
289: 'SYSTEM', -- rule_generation_type
290: 'PENDING', -- status
291: SYSDATE, -- creation_date
292: FND_GLOBAL.USER_ID, -- created_by
293: 0, -- last_updated_by
294: SYSDATE, -- last_update_date
295: FND_GLOBAL.LOGIN_ID, -- last_update_login
296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

Line 295: FND_GLOBAL.LOGIN_ID, -- last_update_login

291: SYSDATE, -- creation_date
292: FND_GLOBAL.USER_ID, -- created_by
293: 0, -- last_updated_by
294: SYSDATE, -- last_update_date
295: FND_GLOBAL.LOGIN_ID, -- last_update_login
296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
297: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
298: SYSDATE, -- program_update_date
299: FND_GLOBAL.CONC_REQUEST_ID -- request_id

Line 296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

292: FND_GLOBAL.USER_ID, -- created_by
293: 0, -- last_updated_by
294: SYSDATE, -- last_update_date
295: FND_GLOBAL.LOGIN_ID, -- last_update_login
296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
297: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
298: SYSDATE, -- program_update_date
299: FND_GLOBAL.CONC_REQUEST_ID -- request_id
300: );

Line 297: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id

293: 0, -- last_updated_by
294: SYSDATE, -- last_update_date
295: FND_GLOBAL.LOGIN_ID, -- last_update_login
296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
297: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
298: SYSDATE, -- program_update_date
299: FND_GLOBAL.CONC_REQUEST_ID -- request_id
300: );
301: EXCEPTION

Line 299: FND_GLOBAL.CONC_REQUEST_ID -- request_id

295: FND_GLOBAL.LOGIN_ID, -- last_update_login
296: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
297: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
298: SYSDATE, -- program_update_date
299: FND_GLOBAL.CONC_REQUEST_ID -- request_id
300: );
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF (SQLCODE <> -20001) THEN

Line 343: FND_GLOBAL.USER_ID, -- created_by

339: ap_utilities_pkg.ap_round_currency(l_amount_to_prorate * amount /
340: l_prorating_total, l_inv_curr_code),
341: -- amount
342: SYSDATE, -- creation_date
343: FND_GLOBAL.USER_ID, -- created_by
344: 0, -- last_updated_by
345: SYSDATE, -- last_update_date
346: FND_GLOBAL.LOGIN_ID, -- last_update_login
347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

Line 346: FND_GLOBAL.LOGIN_ID, -- last_update_login

342: SYSDATE, -- creation_date
343: FND_GLOBAL.USER_ID, -- created_by
344: 0, -- last_updated_by
345: SYSDATE, -- last_update_date
346: FND_GLOBAL.LOGIN_ID, -- last_update_login
347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
349: SYSDATE, -- program_update_date
350: FND_GLOBAL.CONC_REQUEST_ID -- request_id

Line 347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

343: FND_GLOBAL.USER_ID, -- created_by
344: 0, -- last_updated_by
345: SYSDATE, -- last_update_date
346: FND_GLOBAL.LOGIN_ID, -- last_update_login
347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
349: SYSDATE, -- program_update_date
350: FND_GLOBAL.CONC_REQUEST_ID -- request_id
351: FROM ap_invoice_lines

Line 348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id

344: 0, -- last_updated_by
345: SYSDATE, -- last_update_date
346: FND_GLOBAL.LOGIN_ID, -- last_update_login
347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
349: SYSDATE, -- program_update_date
350: FND_GLOBAL.CONC_REQUEST_ID -- request_id
351: FROM ap_invoice_lines
352: WHERE invoice_id = X_invoice_id

Line 350: FND_GLOBAL.CONC_REQUEST_ID -- request_id

346: FND_GLOBAL.LOGIN_ID, -- last_update_login
347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
349: SYSDATE, -- program_update_date
350: FND_GLOBAL.CONC_REQUEST_ID -- request_id
351: FROM ap_invoice_lines
352: WHERE invoice_id = X_invoice_id
353: AND line_number <> X_line_number
354: AND line_group_number = l_line_group_number

Line 462: fnd_global.user_id,

458: 'PERCENTAGE',
459: x_rule_generation_type,
460: x_status,
461: sysdate,
462: fnd_global.user_id,
463: fnd_global.user_id,
464: sysdate,
465: fnd_global.login_id,
466: NULL,

Line 463: fnd_global.user_id,

459: x_rule_generation_type,
460: x_status,
461: sysdate,
462: fnd_global.user_id,
463: fnd_global.user_id,
464: sysdate,
465: fnd_global.login_id,
466: NULL,
467: NULL,

Line 465: fnd_global.login_id,

461: sysdate,
462: fnd_global.user_id,
463: fnd_global.user_id,
464: sysdate,
465: fnd_global.login_id,
466: NULL,
467: NULL,
468: NULL,
469: NULL);

Line 495: fnd_global.user_id,

491: x_to_line_number,
492: x_percentage,
493: NULL,
494: sysdate,
495: fnd_global.user_id,
496: fnd_global.user_id,
497: sysdate,
498: fnd_global.login_id,
499: NULL,

Line 496: fnd_global.user_id,

492: x_percentage,
493: NULL,
494: sysdate,
495: fnd_global.user_id,
496: fnd_global.user_id,
497: sysdate,
498: fnd_global.login_id,
499: NULL,
500: NULL,

Line 498: fnd_global.login_id,

494: sysdate,
495: fnd_global.user_id,
496: fnd_global.user_id,
497: sysdate,
498: fnd_global.login_id,
499: NULL,
500: NULL,
501: NULL,
502: NULL);

Line 888: FND_GLOBAL.USER_ID, -- created_by

884: 'PRORATION', -- rule_type
885: 'USER', -- rule_generation_type
886: 'PENDING', -- status
887: SYSDATE, -- creation_date
888: FND_GLOBAL.USER_ID, -- created_by
889: 0, -- last_updated_by
890: SYSDATE, -- last_update_date
891: FND_GLOBAL.LOGIN_ID, -- last_update_login
892: NULL, -- program_application_id

Line 891: FND_GLOBAL.LOGIN_ID, -- last_update_login

887: SYSDATE, -- creation_date
888: FND_GLOBAL.USER_ID, -- created_by
889: 0, -- last_updated_by
890: SYSDATE, -- last_update_date
891: FND_GLOBAL.LOGIN_ID, -- last_update_login
892: NULL, -- program_application_id
893: NULL, -- program_id
894: SYSDATE, -- program_update_date
895: NULL -- request_id

Line 949: FND_GLOBAL.USER_ID, -- created_by

945: ap_utilities_pkg.ap_round_currency(l_amount_to_prorate * amount /
946: l_prorating_total, l_inv_curr_code),
947: -- amount
948: SYSDATE, -- creation_date
949: FND_GLOBAL.USER_ID, -- created_by
950: 0, -- last_updated_by
951: SYSDATE, -- last_update_date
952: FND_GLOBAL.LOGIN_ID, -- last_update_login
953: NULL, -- program_application_id

Line 952: FND_GLOBAL.LOGIN_ID, -- last_update_login

948: SYSDATE, -- creation_date
949: FND_GLOBAL.USER_ID, -- created_by
950: 0, -- last_updated_by
951: SYSDATE, -- last_update_date
952: FND_GLOBAL.LOGIN_ID, -- last_update_login
953: NULL, -- program_application_id
954: NULL, -- program_id
955: SYSDATE, -- program_update_date
956: NULL -- request_id

Line 1004: FND_GLOBAL.USER_ID, -- created_by

1000: ap_utilities_pkg.ap_round_currency(l_amount_to_prorate * amount /
1001: l_prorating_total, l_inv_curr_code),
1002: -- amount
1003: SYSDATE, -- creation_date
1004: FND_GLOBAL.USER_ID, -- created_by
1005: 0, -- last_updated_by
1006: SYSDATE, -- last_update_date
1007: FND_GLOBAL.LOGIN_ID, -- last_update_login
1008: NULL, -- program_application_id

Line 1007: FND_GLOBAL.LOGIN_ID, -- last_update_login

1003: SYSDATE, -- creation_date
1004: FND_GLOBAL.USER_ID, -- created_by
1005: 0, -- last_updated_by
1006: SYSDATE, -- last_update_date
1007: FND_GLOBAL.LOGIN_ID, -- last_update_login
1008: NULL, -- program_application_id
1009: NULL, -- program_id
1010: SYSDATE, -- program_update_date
1011: NULL -- request_id

Line 1282: FND_GLOBAL.USER_ID, -- created_by

1278: X_to_invoice_line_number, -- to_invoice_line_number
1279: X_allocated_percentage, -- percentage
1280: X_allocated_Amount, -- amount
1281: SYSDATE, -- creation_date
1282: FND_GLOBAL.USER_ID, -- created_by
1283: SYSDATE, -- last_update_date
1284: FND_GLOBAL.USER_ID, -- last_updated_by
1285: FND_GLOBAL.LOGIN_ID, -- last_update_login
1286: NULL, -- program_application_id

Line 1284: FND_GLOBAL.USER_ID, -- last_updated_by

1280: X_allocated_Amount, -- amount
1281: SYSDATE, -- creation_date
1282: FND_GLOBAL.USER_ID, -- created_by
1283: SYSDATE, -- last_update_date
1284: FND_GLOBAL.USER_ID, -- last_updated_by
1285: FND_GLOBAL.LOGIN_ID, -- last_update_login
1286: NULL, -- program_application_id
1287: NULL, -- program_id
1288: NULL, -- program_update_date

Line 1285: FND_GLOBAL.LOGIN_ID, -- last_update_login

1281: SYSDATE, -- creation_date
1282: FND_GLOBAL.USER_ID, -- created_by
1283: SYSDATE, -- last_update_date
1284: FND_GLOBAL.USER_ID, -- last_updated_by
1285: FND_GLOBAL.LOGIN_ID, -- last_update_login
1286: NULL, -- program_application_id
1287: NULL, -- program_id
1288: NULL, -- program_update_date
1289: NULL -- request_id

Line 1355: last_updated_by = FND_GLOBAL.user_id,

1351: UPDATE ap_allocation_rule_lines
1352: SET Amount = X_allocated_AMount,
1353: percentage = X_allocated_percentage,
1354: last_update_date = SYSDATE,
1355: last_updated_by = FND_GLOBAL.user_id,
1356: last_update_login = FND_GLOBAL.login_id
1357: WHERE invoice_id = X_invoice_id
1358: AND chrg_invoice_line_number = X_chrg_invoice_line_number
1359: AND to_invoice_line_number = X_to_invoice_line_number;

Line 1356: last_update_login = FND_GLOBAL.login_id

1352: SET Amount = X_allocated_AMount,
1353: percentage = X_allocated_percentage,
1354: last_update_date = SYSDATE,
1355: last_updated_by = FND_GLOBAL.user_id,
1356: last_update_login = FND_GLOBAL.login_id
1357: WHERE invoice_id = X_invoice_id
1358: AND chrg_invoice_line_number = X_chrg_invoice_line_number
1359: AND to_invoice_line_number = X_to_invoice_line_number;
1360:

Line 1794: last_updated_by = FND_GLOBAL.USER_ID,

1790: UPDATE ap_allocation_rule_lines
1791: SET amount = ap_utilities_pkg.ap_round_currency(
1792: l_amount_to_prorate*amount/
1793: l_prorating_total, l_inv_curr_code),
1794: last_updated_by = FND_GLOBAL.USER_ID,
1795: last_update_date = SYSDATE,
1796: last_update_login = FND_GLOBAL.LOGIN_ID
1797: WHERE invoice_id = X_invoice_id
1798: AND chrg_invoice_line_number = X_chrg_line_number;

Line 1796: last_update_login = FND_GLOBAL.LOGIN_ID

1792: l_amount_to_prorate*amount/
1793: l_prorating_total, l_inv_curr_code),
1794: last_updated_by = FND_GLOBAL.USER_ID,
1795: last_update_date = SYSDATE,
1796: last_update_login = FND_GLOBAL.LOGIN_ID
1797: WHERE invoice_id = X_invoice_id
1798: AND chrg_invoice_line_number = X_chrg_line_number;
1799:
1800: EXCEPTION

Line 2205: FND_GLOBAL.USER_ID, -- created_by

2201: 'AMOUNT', -- rule_type
2202: 'SYSTEM', -- rule_generation_type
2203: 'EXECUTED', -- status
2204: SYSDATE, -- creation_date
2205: FND_GLOBAL.USER_ID, -- created_by
2206: FND_GLOBAL.USER_ID, -- last_updated_by
2207: SYSDATE, -- last_update_date
2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

Line 2206: FND_GLOBAL.USER_ID, -- last_updated_by

2202: 'SYSTEM', -- rule_generation_type
2203: 'EXECUTED', -- status
2204: SYSDATE, -- creation_date
2205: FND_GLOBAL.USER_ID, -- created_by
2206: FND_GLOBAL.USER_ID, -- last_updated_by
2207: SYSDATE, -- last_update_date
2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id

Line 2208: FND_GLOBAL.LOGIN_ID, -- last_update_login

2204: SYSDATE, -- creation_date
2205: FND_GLOBAL.USER_ID, -- created_by
2206: FND_GLOBAL.USER_ID, -- last_updated_by
2207: SYSDATE, -- last_update_date
2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
2211: SYSDATE, -- program_update_date
2212: FND_GLOBAL.CONC_REQUEST_ID -- request_id

Line 2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

2205: FND_GLOBAL.USER_ID, -- created_by
2206: FND_GLOBAL.USER_ID, -- last_updated_by
2207: SYSDATE, -- last_update_date
2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
2211: SYSDATE, -- program_update_date
2212: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2213: );

Line 2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id

2206: FND_GLOBAL.USER_ID, -- last_updated_by
2207: SYSDATE, -- last_update_date
2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
2211: SYSDATE, -- program_update_date
2212: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2213: );
2214: EXCEPTION

Line 2212: FND_GLOBAL.CONC_REQUEST_ID -- request_id

2208: FND_GLOBAL.LOGIN_ID, -- last_update_login
2209: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2210: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
2211: SYSDATE, -- program_update_date
2212: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2213: );
2214: EXCEPTION
2215: WHEN OTHERS THEN
2216: IF (SQLCODE <> -20001) THEN

Line 2251: FND_GLOBAL.USER_ID, -- created_by

2247: x_chrg_line_number, -- chrg_invoice_line_number
2248: zxl.trx_line_number, -- to_invoice_line_number
2249: sum(zxl.tax_amt), -- amount
2250: SYSDATE, -- creation_date
2251: FND_GLOBAL.USER_ID, -- created_by
2252: FND_GLOBAL.USER_ID, -- last_updated_by
2253: SYSDATE, -- last_update_date
2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

Line 2252: FND_GLOBAL.USER_ID, -- last_updated_by

2248: zxl.trx_line_number, -- to_invoice_line_number
2249: sum(zxl.tax_amt), -- amount
2250: SYSDATE, -- creation_date
2251: FND_GLOBAL.USER_ID, -- created_by
2252: FND_GLOBAL.USER_ID, -- last_updated_by
2253: SYSDATE, -- last_update_date
2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id

Line 2254: FND_GLOBAL.LOGIN_ID, -- last_update_login

2250: SYSDATE, -- creation_date
2251: FND_GLOBAL.USER_ID, -- created_by
2252: FND_GLOBAL.USER_ID, -- last_updated_by
2253: SYSDATE, -- last_update_date
2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
2257: SYSDATE, -- program_update_date
2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id

Line 2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id

2251: FND_GLOBAL.USER_ID, -- created_by
2252: FND_GLOBAL.USER_ID, -- last_updated_by
2253: SYSDATE, -- last_update_date
2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
2257: SYSDATE, -- program_update_date
2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2259: FROM zx_lines zxl,

Line 2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id

2252: FND_GLOBAL.USER_ID, -- last_updated_by
2253: SYSDATE, -- last_update_date
2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
2257: SYSDATE, -- program_update_date
2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2259: FROM zx_lines zxl,
2260: ap_invoice_lines apl

Line 2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id

2254: FND_GLOBAL.LOGIN_ID, -- last_update_login
2255: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
2257: SYSDATE, -- program_update_date
2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2259: FROM zx_lines zxl,
2260: ap_invoice_lines apl
2261: WHERE apl.invoice_id = x_invoice_id
2262: AND apl.line_number = x_chrg_line_number