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 180: ln_created_by := FND_GLOBAL.user_id;

176: BEGIN
177:
178: -- added, Harshita for Bug 4762433
179: ld_creation_date := SYSDATE;
180: ln_created_by := FND_GLOBAL.user_id;
181:
182: FOR MAIN IN MAP_IDENT
183: LOOP
184:

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

1064: CUSTOMER_TRX_ID, CUSTOMER_ID, TRX_DATE, SUPP_INV_TYPE, LAST_UPDATE_DATE, CREATED_BY,
1065: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1066: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1067: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1068: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1069: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1070: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1071: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1072:

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

1065: CREATION_DATE, LAST_UPDATED_BY, EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT,
1066: SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1067: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1068: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS, SYSDATE, fnd_global.user_id,
1069: SYSDATE, fnd_global.user_id, OAMOUNT, NAMOUNT,
1070: I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1071: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1072:
1073: ELSE

Line 1101: SYSDATE, fnd_global.user_id, NULL,

1097: ) VALUES (
1098: FETCH_INV.CUSTOMER_TRX_ID, v_cust_trx_line_no_s, I.INVENTORY_ITEM_ID, I.LINE_NUMBER, STATUS,
1099: I.DESCRIPTION, AQUANTITY, AUNIT_CODE, ATAX_CATEGORY_ID,
1100: ASELLING_PRICE, C_LIST_PRICE, OAMOUNT, NAMOUNT,
1101: SYSDATE, fnd_global.user_id, NULL,
1102: SYSDATE, fnd_global.user_id, v_p_mapping_id,v_cust_trx_line_no_s
1103: );
1104:
1105: END IF;

Line 1102: SYSDATE, fnd_global.user_id, v_p_mapping_id,v_cust_trx_line_no_s

1098: FETCH_INV.CUSTOMER_TRX_ID, v_cust_trx_line_no_s, I.INVENTORY_ITEM_ID, I.LINE_NUMBER, STATUS,
1099: I.DESCRIPTION, AQUANTITY, AUNIT_CODE, ATAX_CATEGORY_ID,
1100: ASELLING_PRICE, C_LIST_PRICE, OAMOUNT, NAMOUNT,
1101: SYSDATE, fnd_global.user_id, NULL,
1102: SYSDATE, fnd_global.user_id, v_p_mapping_id,v_cust_trx_line_no_s
1103: );
1104:
1105: END IF;
1106:

Line 1205: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,

1201: EXIST_NET_SALES_AMT, NEW_NET_SALES_AMT, SET_OF_BOOKS_ID,
1202: CUSTOMER_SITE, ORG_ID, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1203: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1204: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1205: SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.user_id,
1206: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, I.SET_OF_BOOKS_ID,
1207: I.BILL_TO_SITE_USE_ID, I.ORG_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1208: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1209:

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

1232: ) VALUES (
1233: FETCH_INV.CUSTOMER_TRX_ID, v_cust_trx_line_no_s, I.INVENTORY_ITEM_ID, I.LINE_NUMBER,
1234: I.DESCRIPTION, STATUS, AQUANTITY, AUNIT_CODE,
1235: ATAX_CATEGORY_ID, I_UNIT_SELLING_PRICE, C_LIST_PRICE,
1236: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, SYSDATE, fnd_global.user_id,
1237: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,v_cust_trx_line_no_s
1238: );
1239:
1240: END IF;

Line 1237: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,v_cust_trx_line_no_s

1233: FETCH_INV.CUSTOMER_TRX_ID, v_cust_trx_line_no_s, I.INVENTORY_ITEM_ID, I.LINE_NUMBER,
1234: I.DESCRIPTION, STATUS, AQUANTITY, AUNIT_CODE,
1235: ATAX_CATEGORY_ID, I_UNIT_SELLING_PRICE, C_LIST_PRICE,
1236: OLD_INVOICE_AMOUNT, NEW_INVOICE_AMOUNT, SYSDATE, fnd_global.user_id,
1237: NULL, SYSDATE, fnd_global.user_id, v_I_mapping_id,v_cust_trx_line_no_s
1238: );
1239:
1240: END IF;
1241:

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

1529:
1530: jai_ar_sup_trx_pkg.calculate_tax('OE_LINES_UPDATE',ATAX_CATEGORY_ID,I.CUSTOMER_TRX_LINE_ID,
1531: pack_assess ,PASSING_AMOUNT,NVL(FETCH_INV.CONVERSION_RATE,1),
1532: I.Inventory_item_id,Aquantity, AUNIT_CODE,NULL,
1533: NULL, NULL, SYSDATE,fnd_global.user_id,fnd_global.user_id );
1534: END IF;
1535:
1536: v_statement_id := '69';
1537: IF ASSESSABLE_LIST_CHANGE = 'Y'

Line 1603: SYSDATE, fnd_global.user_id, NULL, SYSDATE, fnd_global.user_id,v_cust_trx_line_no_s

1599: ) VALUES (
1600: FETCH_INV.CUSTOMER_TRX_ID, v_cust_trx_line_no_s, I.LINE_NUMBER, STATUS,
1601: I.INVENTORY_ITEM_ID, I.DESCRIPTION, AQUANTITY, AUNIT_CODE,
1602: ATAX_CATEGORY_ID, O_A_VAL, N_A_VAL, v_a_mapping_id,
1603: SYSDATE, fnd_global.user_id, NULL, SYSDATE, fnd_global.user_id,v_cust_trx_line_no_s
1604: );
1605:
1606: ELSIF CHECK_SUPP_LINES%FOUND AND STATUS IN ('SI','CR')
1607: AND TAX_DIFFER1 <> 0

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

1640: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE,
1641: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1642: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1643: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1644: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1645: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1646: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1647:
1648: END IF;

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

1641: CREATED_BY, SET_OF_BOOKS_ID, ORG_ID, CUSTOMER_SITE, BATCH_ID, SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1642: ) VALUES ( JAI_AR_SUP_HDRS_ALL_S.nextval,
1643: FETCH_INV.CUSTOMER_TRX_ID, I.BILL_TO_CUSTOMER_ID, FETCH_INV.TRX_DATE, STATUS,
1644: SYSDATE, fnd_global.user_id, NULL, SYSDATE,
1645: fnd_global.user_id, I.SET_OF_BOOKS_ID, I.ORG_ID, I.BILL_TO_SITE_USE_ID, FETCH_INV.BATCH_ID, 'N', 'N'
1646: );--Bgowrava for Bug#6400997, added SUPP_INV_RAISED_IND, CHOSEN_FOR_PROCESS
1647:
1648: END IF;
1649:

Line 1702: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,

1698: B.PRECEDENCE_1, B.PRECEDENCE_2, B.PRECEDENCE_3, B.PRECEDENCE_4, B.PRECEDENCE_5,
1699: B.PRECEDENCE_6, B.PRECEDENCE_7, B.PRECEDENCE_8, B.PRECEDENCE_9, B.PRECEDENCE_10,
1700: A.TAX_AMOUNT, B.TAX_AMOUNT,
1701: A.BASE_TAX_AMOUNT, B.BASE_TAX_AMOUNT, A.FUNC_TAX_AMOUNT, B.FUNC_TAX_AMOUNT,
1702: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,
1703: NULL, SYSDATE, fnd_global.user_id
1704: );
1705:
1706: v_statement_id := '84';

Line 1703: NULL, SYSDATE, fnd_global.user_id

1699: B.PRECEDENCE_6, B.PRECEDENCE_7, B.PRECEDENCE_8, B.PRECEDENCE_9, B.PRECEDENCE_10,
1700: A.TAX_AMOUNT, B.TAX_AMOUNT,
1701: A.BASE_TAX_AMOUNT, B.BASE_TAX_AMOUNT, A.FUNC_TAX_AMOUNT, B.FUNC_TAX_AMOUNT,
1702: TAX_DIFF_AMT, SYSDATE, fnd_global.user_id,
1703: NULL, SYSDATE, fnd_global.user_id
1704: );
1705:
1706: v_statement_id := '84';
1707: IF A.TAX_LINE_NO = B.TAX_LINE_NO THEN

Line 2199: fnd_global.user_id,

2195: supp_inv.organization_id,
2196: supp_inv.organization_id,
2197: supp_inv_line.quantity,
2198: decode(v_amount,0,0,v_sp_diff),
2199: fnd_global.user_id,
2200: sysdate,
2201: fnd_global.user_id,
2202: sysdate,
2203: null ,

Line 2201: fnd_global.user_id,

2197: supp_inv_line.quantity,
2198: decode(v_amount,0,0,v_sp_diff),
2199: fnd_global.user_id,
2200: sysdate,
2201: fnd_global.user_id,
2202: sysdate,
2203: null ,
2204: ln_legal_entity_id ,
2205: SUPP_INV.org_id

Line 2234: fnd_global.user_id,

2230: supp_inv_line.interface_line_attribute2,
2231: supp_inv_line.customer_trx_line_id,
2232: End of Bug# 4392001 */
2233: sales_crdt.sales_credit_type_id,
2234: fnd_global.user_id,
2235: sysdate,
2236: fnd_global.user_id,
2237: sysdate);
2238: END LOOP;

Line 2236: fnd_global.user_id,

2232: End of Bug# 4392001 */
2233: sales_crdt.sales_credit_type_id,
2234: fnd_global.user_id,
2235: sysdate,
2236: fnd_global.user_id,
2237: sysdate);
2238: END LOOP;
2239: END LOOP;
2240:

Line 2246: LAST_UPDATED_BY = fnd_global.user_id

2242: SET SUPPLEMENTARY_NUM = V_SEQ,
2243: SUPP_INV_DATE = SYSDATE,
2244: SUPP_INV_RAISED_IND = 'Y',
2245: LAST_UPDATE_DATE = SYSDATE,
2246: LAST_UPDATED_BY = fnd_global.user_id
2247: WHERE CUSTOMER_TRX_ID = SUPP_INV.CUSTOMER_TRX_ID
2248: AND SUPP_INV_TYPE = SUPP_INV.SUPP_INV_TYPE
2249: AND CHOSEN_FOR_PROCESS = 'Y';
2250: END LOOP;

Line 2382: fnd_global.user_id,

2378: inv_cnsldt.organization_id, --2001/05/10 Anuradha Parthasarathy
2379: inv_cnsldt.organization_id, --2001/05/10 Anuradha Parthasarathy
2380: inv_cnsldt.quant,
2381: ( inv_cnsldt.AMT/inv_cnsldt.quant),
2382: fnd_global.user_id,
2383: sysdate,
2384: fnd_global.user_id,
2385: sysdate,
2386: null,

Line 2384: fnd_global.user_id,

2380: inv_cnsldt.quant,
2381: ( inv_cnsldt.AMT/inv_cnsldt.quant),
2382: fnd_global.user_id,
2383: sysdate,
2384: fnd_global.user_id,
2385: sysdate,
2386: null,
2387: cnsldt_header.org_id,
2388: ln_legal_entity_id

Line 2424: fnd_global.user_id,

2420: cnlsdt_crdt_amt.interface_line_attribute2,
2421: NULL,
2422: End of Bug# 4392001*/
2423: cnsldt_crdt_rep.sales_credit_type_id,
2424: fnd_global.user_id,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate);
2428: --null;

Line 2426: fnd_global.user_id,

2422: End of Bug# 4392001*/
2423: cnsldt_crdt_rep.sales_credit_type_id,
2424: fnd_global.user_id,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate);
2428: --null;
2429: end loop;
2430: end loop;

Line 2438: LAST_UPDATED_BY = fnd_global.user_id

2434: SET SUPPLEMENTARY_NUM = V_SEQ,
2435: SUPP_INV_DATE = SYSDATE,
2436: SUPP_INV_RAISED_IND = 'Y',
2437: LAST_UPDATE_DATE = SYSDATE,
2438: LAST_UPDATED_BY = fnd_global.user_id
2439: WHERE SET_OF_BOOKS_ID = cnsldt_header.set_of_books_id
2440: AND CUSTOMER_ID = cnsldt_header.customer_id
2441: AND CUSTOMER_SITE = cnsldt_header.customer_site
2442: AND supp_inv_type = cnsldt_header.supp_inv_type