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

Line 217: ln_created_by := FND_GLOBAL.user_id;

213: BEGIN
214:
215: -- added, Harshita for Bug 4762433
216: ld_creation_date := SYSDATE;
217: ln_created_by := FND_GLOBAL.user_id;
218:
219: FOR MAIN IN MAP_IDENT
220: LOOP
221:

Line 1169: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,

1165: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1166: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1167: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1168: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1169: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1170: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1171: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1172: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1173:

Line 1170: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,

1166: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1167: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1168: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1169: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1170: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1171: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1172: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1173:
1174: ELSE

Line 1204: SYSDATE, fnd_global.user_id, NULL,

1200: ) VALUES (
1201: FETCH_INV.CUSTOMER_TRX_ID, I.CUSTOMER_TRX_LINE_ID, I.INVENTORY_ITEM_ID, I.LINE_NUMBER, STATUS,
1202: I.DESCRIPTION, AQUANTITY, AUNIT_CODE, ATAX_CATEGORY_ID,
1203: ASELLING_PRICE, C_LIST_PRICE, OAMOUNT, NAMOUNT,
1204: SYSDATE, fnd_global.user_id, NULL,
1205: SYSDATE, fnd_global.user_id, v_p_mapping_id,I.CUSTOMER_TRX_LINE_ID
1206: );
1207:
1208: END IF;

Line 1205: SYSDATE, fnd_global.user_id, v_p_mapping_id,I.CUSTOMER_TRX_LINE_ID

1201: FETCH_INV.CUSTOMER_TRX_ID, I.CUSTOMER_TRX_LINE_ID, I.INVENTORY_ITEM_ID, I.LINE_NUMBER, STATUS,
1202: I.DESCRIPTION, AQUANTITY, AUNIT_CODE, ATAX_CATEGORY_ID,
1203: ASELLING_PRICE, C_LIST_PRICE, OAMOUNT, NAMOUNT,
1204: SYSDATE, fnd_global.user_id, NULL,
1205: SYSDATE, fnd_global.user_id, v_p_mapping_id,I.CUSTOMER_TRX_LINE_ID
1206: );
1207:
1208: END IF;
1209:

Line 1316: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,

1312: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1313: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1314: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1315: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1316: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,
1317: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, I.SET_OF_BOOKS_ID,
1318: I.BILL_TO_SITE_USE_ID, I.ORG_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1319: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1320:

Line 1347: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, SYSDATE, fnd_global.user_id,

1343: ) VALUES (
1344: FETCH_INV.CUSTOMER_TRX_ID, I.CUSTOMER_TRX_LINE_ID, I.INVENTORY_ITEM_ID, I.LINE_NUMBER,
1345: I.DESCRIPTION, STATUS, AQUANTITY, AUNIT_CODE,
1346: ATAX_CATEGORY_ID, I_UNIT_SELLING_PRICE, C_LIST_PRICE,
1347: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, SYSDATE, fnd_global.user_id,
1348: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,I.CUSTOMER_TRX_LINE_ID
1349: );
1350:
1351: END IF;

Line 1348: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,I.CUSTOMER_TRX_LINE_ID

1344: FETCH_INV.CUSTOMER_TRX_ID, I.CUSTOMER_TRX_LINE_ID, I.INVENTORY_ITEM_ID, I.LINE_NUMBER,
1345: I.DESCRIPTION, STATUS, AQUANTITY, AUNIT_CODE,
1346: ATAX_CATEGORY_ID, I_UNIT_SELLING_PRICE, C_LIST_PRICE,
1347: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, SYSDATE, fnd_global.user_id,
1348: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,I.CUSTOMER_TRX_LINE_ID
1349: );
1350:
1351: END IF;
1352:

Line 1658: NULL, NULL, SYSDATE,fnd_global.user_id,fnd_global.user_id );

1654:
1655: jai_ar_sup_trx_pkg.calculate_tax('OE_LINES_UPDATE',ATAX_CATEGORY_ID,I.CUSTOMER_TRX_LINE_ID,
1656: pack_assess ,PASSING_AMOUNT,NVL(FETCH_INV.CONVERSION_RATE,1),
1657: I.Inventory_item_id,Aquantity, AUNIT_CODE,NULL,
1658: NULL, NULL, SYSDATE,fnd_global.user_id,fnd_global.user_id );
1659: END IF;
1660:
1661: v_statement_id := '69';
1662: IF ASSESSABLE_LIST_CHANGE = 'Y'

Line 1730: SYSDATE, fnd_global.user_id, NULL, SYSDATE, fnd_global.user_id,I.CUSTOMER_TRX_LINE_ID

1726: ) VALUES (
1727: FETCH_INV.CUSTOMER_TRX_ID, I.CUSTOMER_TRX_LINE_ID, I.LINE_NUMBER, STATUS,
1728: I.INVENTORY_ITEM_ID, I.DESCRIPTION, AQUANTITY, AUNIT_CODE,
1729: ATAX_CATEGORY_ID, O_A_VAL, N_A_VAL, v_a_mapping_id,
1730: SYSDATE, fnd_global.user_id, NULL, SYSDATE, fnd_global.user_id,I.CUSTOMER_TRX_LINE_ID
1731: );
1732:
1733: ELSIF CHECK_SUPP_LINES%FOUND AND STATUS IN ('SI','CR')
1734: AND TAX_DIFFER1 <> 0

Line 1771: SYSDATE, fnd_global.user_id, NULL, SYSDATE,

1767: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1768: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1769: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1770: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1771: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1772: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1773: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1774:
1775: END IF;

Line 1772: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'

1768: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1769: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1770: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1771: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1772: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1773: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1774:
1775: END IF;
1776:

Line 1829: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,

1825: B.PRECEDENCE_1, B.PRECEDENCE_2, B.PRECEDENCE_3, B.PRECEDENCE_4, B.PRECEDENCE_5,
1826: B.PRECEDENCE_6, B.PRECEDENCE_7, B.PRECEDENCE_8, B.PRECEDENCE_9, B.PRECEDENCE_10,
1827: A.TAX_AMOUNT, B.TAX_AMOUNT,
1828: A.BASE_TAX_AMOUNT, B.BASE_TAX_AMOUNT, A.FUNC_TAX_AMOUNT, B.FUNC_TAX_AMOUNT,
1829: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,
1830: NULL, SYSDATE, fnd_global.user_id
1831: );
1832:
1833: v_statement_id := '84';

Line 1830: NULL, SYSDATE, fnd_global.user_id

1826: B.PRECEDENCE_6, B.PRECEDENCE_7, B.PRECEDENCE_8, B.PRECEDENCE_9, B.PRECEDENCE_10,
1827: A.TAX_AMOUNT, B.TAX_AMOUNT,
1828: A.BASE_TAX_AMOUNT, B.BASE_TAX_AMOUNT, A.FUNC_TAX_AMOUNT, B.FUNC_TAX_AMOUNT,
1829: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,
1830: NULL, SYSDATE, fnd_global.user_id
1831: );
1832:
1833: v_statement_id := '84';
1834: IF A.TAX_LINE_NO = B.TAX_LINE_NO THEN

Line 2337: fnd_global.user_id,

2333: supp_inv.organization_id,
2334: supp_inv.organization_id,
2335: supp_inv_line.quantity,
2336: decode(v_amount,0,0,v_sp_diff),
2337: fnd_global.user_id,
2338: sysdate,
2339: fnd_global.user_id,
2340: sysdate,
2341: null ,

Line 2339: fnd_global.user_id,

2335: supp_inv_line.quantity,
2336: decode(v_amount,0,0,v_sp_diff),
2337: fnd_global.user_id,
2338: sysdate,
2339: fnd_global.user_id,
2340: sysdate,
2341: null ,
2342: ln_legal_entity_id ,
2343: SUPP_INV.org_id

Line 2372: fnd_global.user_id,

2368: supp_inv_line.interface_line_attribute2,
2369: supp_inv_line.customer_trx_line_id,
2370: End of Bug# 4392001 */
2371: sales_crdt.sales_credit_type_id,
2372: fnd_global.user_id,
2373: sysdate,
2374: fnd_global.user_id,
2375: sysdate);
2376: END LOOP;

Line 2374: fnd_global.user_id,

2370: End of Bug# 4392001 */
2371: sales_crdt.sales_credit_type_id,
2372: fnd_global.user_id,
2373: sysdate,
2374: fnd_global.user_id,
2375: sysdate);
2376: END LOOP;
2377: END LOOP;
2378:

Line 2384: LAST_UPDATED_BY = fnd_global.user_id

2380: SET SUPPLEMENTARY_NUM = V_SEQ,
2381: SUPP_INV_DATE = SYSDATE,
2382: SUPP_INV_RAISED_IND = 'Y',
2383: LAST_UPDATE_DATE = SYSDATE,
2384: LAST_UPDATED_BY = fnd_global.user_id
2385: WHERE CUSTOMER_TRX_ID = SUPP_INV.CUSTOMER_TRX_ID
2386: AND SUPP_INV_TYPE = SUPP_INV.SUPP_INV_TYPE
2387: AND CHOSEN_FOR_PROCESS = 'Y';
2388: END LOOP;

Line 2520: fnd_global.user_id,

2516: inv_cnsldt.organization_id, --2001/05/10 Anuradha Parthasarathy
2517: inv_cnsldt.organization_id, --2001/05/10 Anuradha Parthasarathy
2518: inv_cnsldt.quant,
2519: ( inv_cnsldt.AMT/inv_cnsldt.quant),
2520: fnd_global.user_id,
2521: sysdate,
2522: fnd_global.user_id,
2523: sysdate,
2524: null,

Line 2522: fnd_global.user_id,

2518: inv_cnsldt.quant,
2519: ( inv_cnsldt.AMT/inv_cnsldt.quant),
2520: fnd_global.user_id,
2521: sysdate,
2522: fnd_global.user_id,
2523: sysdate,
2524: null,
2525: cnsldt_header.org_id,
2526: ln_legal_entity_id

Line 2562: fnd_global.user_id,

2558: cnlsdt_crdt_amt.interface_line_attribute2,
2559: NULL,
2560: End of Bug# 4392001*/
2561: cnsldt_crdt_rep.sales_credit_type_id,
2562: fnd_global.user_id,
2563: sysdate,
2564: fnd_global.user_id,
2565: sysdate);
2566: --null;

Line 2564: fnd_global.user_id,

2560: End of Bug# 4392001*/
2561: cnsldt_crdt_rep.sales_credit_type_id,
2562: fnd_global.user_id,
2563: sysdate,
2564: fnd_global.user_id,
2565: sysdate);
2566: --null;
2567: end loop;
2568: end loop;

Line 2576: LAST_UPDATED_BY = fnd_global.user_id

2572: SET SUPPLEMENTARY_NUM = V_SEQ,
2573: SUPP_INV_DATE = SYSDATE,
2574: SUPP_INV_RAISED_IND = 'Y',
2575: LAST_UPDATE_DATE = SYSDATE,
2576: LAST_UPDATED_BY = fnd_global.user_id
2577: WHERE SET_OF_BOOKS_ID = cnsldt_header.set_of_books_id
2578: AND CUSTOMER_ID = cnsldt_header.customer_id
2579: AND CUSTOMER_SITE = cnsldt_header.customer_site
2580: AND supp_inv_type = cnsldt_header.supp_inv_type