DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on FND_GLOBAL

Line 1483: l_cnsld_invs(i).cin_rec.CREATED_BY := fnd_global.user_id ;

1479: l_cnsld_invs(i).cin_rec.LEGAL_ENTITY_ID := r_invoice.LEGAL_ENTITY_ID ;
1480: l_cnsld_invs(i).cin_rec.VPA_ID := r_invoice.VPA_ID ;
1481: l_cnsld_invs(i).cin_rec.OBJECT_VERSION_NUMBER := i ;
1482: -- l_cnsld_invs(i).cin_rec.CREATED_BY := i ; -- cklee 04/26/07
1483: l_cnsld_invs(i).cin_rec.CREATED_BY := fnd_global.user_id ;
1484: l_cnsld_invs(i).cin_rec.CREATION_DATE := sysdate ;
1485: -- l_cnsld_invs(i).cin_rec.LAST_UPDATED_BY := i ; -- cklee 04/26/07
1486: l_cnsld_invs(i).cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;
1487: l_cnsld_invs(i).cin_rec.LAST_UPDATE_DATE := sysdate ;

Line 1486: l_cnsld_invs(i).cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;

1482: -- l_cnsld_invs(i).cin_rec.CREATED_BY := i ; -- cklee 04/26/07
1483: l_cnsld_invs(i).cin_rec.CREATED_BY := fnd_global.user_id ;
1484: l_cnsld_invs(i).cin_rec.CREATION_DATE := sysdate ;
1485: -- l_cnsld_invs(i).cin_rec.LAST_UPDATED_BY := i ; -- cklee 04/26/07
1486: l_cnsld_invs(i).cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;
1487: l_cnsld_invs(i).cin_rec.LAST_UPDATE_DATE := sysdate ;
1488:
1489: --start:| 03-MAY-2007 cklee -- Disbursement changes for R12B, bug fixed: |
1490: l_cnsld_invs(i).cin_rec.accts_pay_cc_id := NVL(r_invoice.tap_ccid,r_invoice.cr_ccid);

Line 1531: l_cnsld_invs(i).tplv_tbl(j).CREATED_BY := fnd_global.user_id;

1527: l_cnsld_invs(i).tplv_tbl(j).SEL_ID := r_invoice.SEL_ID;
1528: l_cnsld_invs(i).tplv_tbl(j).TAXABLE_YN := r_invoice.TAXABLE_YN;
1529: l_cnsld_invs(i).tplv_tbl(j).ORG_ID := r_invoice.ORG_ID;
1530: -- l_cnsld_invs(i).tplv_tbl(j).CREATED_BY := i; -- cklee 4/26/07
1531: l_cnsld_invs(i).tplv_tbl(j).CREATED_BY := fnd_global.user_id;
1532: l_cnsld_invs(i).tplv_tbl(j).CREATION_DATE := sysdate;
1533: -- l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATED_BY := i; -- cklee 4/26/07
1534: l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATED_BY := fnd_global.user_id;
1535: l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATE_DATE := sysdate;

Line 1534: l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATED_BY := fnd_global.user_id;

1530: -- l_cnsld_invs(i).tplv_tbl(j).CREATED_BY := i; -- cklee 4/26/07
1531: l_cnsld_invs(i).tplv_tbl(j).CREATED_BY := fnd_global.user_id;
1532: l_cnsld_invs(i).tplv_tbl(j).CREATION_DATE := sysdate;
1533: -- l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATED_BY := i; -- cklee 4/26/07
1534: l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATED_BY := fnd_global.user_id;
1535: l_cnsld_invs(i).tplv_tbl(j).LAST_UPDATE_DATE := sysdate;
1536: --start:| 02-May-2007 cilee Disbursement changes for R12B |
1537: l_cnsld_invs(i).tplv_tbl(j).KHR_ID := r_invoice.KHR_ID;
1538: l_cnsld_invs(i).tplv_tbl(j).REF_LINE_NUMBER := r_invoice.REF_LINE_NUMBER;

Line 2208: l_cin_rec.CREATED_BY := fnd_global.user_id ;

2204: l_cin_rec.VENDOR_ID := r_invoice.VENDOR_ID;
2205: l_cin_rec.LEGAL_ENTITY_ID := r_invoice.LEGAL_ENTITY_ID ;
2206: l_cin_rec.VPA_ID := r_invoice.VPA_ID ;
2207: l_cin_rec.OBJECT_VERSION_NUMBER := 1 ;
2208: l_cin_rec.CREATED_BY := fnd_global.user_id ;
2209: l_cin_rec.CREATION_DATE := sysdate ;
2210: l_cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;
2211: l_cin_rec.LAST_UPDATE_DATE := sysdate ;
2212: l_cin_rec.accts_pay_cc_id := NVL(r_invoice.tap_ccid,r_invoice.cr_ccid);

Line 2210: l_cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;

2206: l_cin_rec.VPA_ID := r_invoice.VPA_ID ;
2207: l_cin_rec.OBJECT_VERSION_NUMBER := 1 ;
2208: l_cin_rec.CREATED_BY := fnd_global.user_id ;
2209: l_cin_rec.CREATION_DATE := sysdate ;
2210: l_cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;
2211: l_cin_rec.LAST_UPDATE_DATE := sysdate ;
2212: l_cin_rec.accts_pay_cc_id := NVL(r_invoice.tap_ccid,r_invoice.cr_ccid);
2213: l_cin_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert
2214:

Line 2213: l_cin_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert

2209: l_cin_rec.CREATION_DATE := sysdate ;
2210: l_cin_rec.LAST_UPDATED_BY := fnd_global.user_id ;
2211: l_cin_rec.LAST_UPDATE_DATE := sysdate ;
2212: l_cin_rec.accts_pay_cc_id := NVL(r_invoice.tap_ccid,r_invoice.cr_ccid);
2213: l_cin_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert
2214:
2215: OKL_CIN_PVT.insert_row(
2216: p_api_version => p_api_version,
2217: p_init_msg_list => p_init_msg_list,

Line 2242: txl.LAST_UPDATED_BY = fnd_global.user_id,

2238: -- 2. update okl_txl_ap_inv_lns_all_b with FK: cnsld_ap_inv_id and cnsld_line_number
2239: UPDATE okl_txl_ap_inv_lns_all_b txl
2240: SET txl.cnsld_ap_inv_id = lx_cin_rec.cnsld_ap_inv_id,
2241: txl.cnsld_line_number = cin_ln_cnt,
2242: txl.LAST_UPDATED_BY = fnd_global.user_id,
2243: txl.LAST_UPDATE_DATE = sysdate,
2244: txl.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2245: WHERE txl.id = r_invoice.tpl_id;
2246: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' update okl_txl_ap_inv_lns_all_b with FK: cnsld_ap_inv_id and cnsld_line_number. cin_ln_cnt:<'

Line 2244: txl.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE

2240: SET txl.cnsld_ap_inv_id = lx_cin_rec.cnsld_ap_inv_id,
2241: txl.cnsld_line_number = cin_ln_cnt,
2242: txl.LAST_UPDATED_BY = fnd_global.user_id,
2243: txl.LAST_UPDATE_DATE = sysdate,
2244: txl.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2245: WHERE txl.id = r_invoice.tpl_id;
2246: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' update okl_txl_ap_inv_lns_all_b with FK: cnsld_ap_inv_id and cnsld_line_number. cin_ln_cnt:<'
2247: || cin_ln_cnt || '>r_invoice.tpl_id:' ||r_invoice.tpl_id || 'lx_cin_rec.cnsld_ap_inv_id:'|| lx_cin_rec.cnsld_ap_inv_id);
2248:

Line 2264: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE

2260: FOR k in l_tplv_tbl.FIRST..l_tplv_tbl.LAST
2261: LOOP
2262: UPDATE OKL_TRX_AP_INVS_ALL_B trx
2263: SET trx.TRX_STATUS_CODE = 'PROCESSED',
2264: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2265: WHERE trx.ID = l_tplv_tbl(k).tap_id
2266: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Processed status.l_tplv_tbl('
2268: ||k||').tap_id'|| l_tplv_tbl(k).tap_id);

Line 2282: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE

2278: LOOP
2279:
2280: UPDATE OKL_TRX_AP_INVS_ALL_B trx
2281: SET trx.TRX_STATUS_CODE = 'ERROR',
2282: trx.REQUEST_ID = Fnd_Global.CONC_REQUEST_ID -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert/UPDATE
2283: WHERE trx.ID = l_tplv_tbl(j).tap_id
2284: AND trx.TRX_STATUS_CODE IN ('ENTERED', 'APPROVED');
2285: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' UPDATE OKL_TRX_AP_INVS_ALL_B with Error status.l_tplv_tbl(' ||j||').tap_id'|| l_tplv_tbl(j).tap_id);
2286:

Line 2772: l_xpiv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert

2768: l_xpiv_rec.currency_conversion_type := r_cnsld_hdr.currency_conversion_type;
2769: l_xpiv_rec.currency_conversion_date := r_cnsld_hdr.currency_conversion_date;
2770: l_xpiv_rec.legal_entity_id := r_cnsld_hdr.legal_entity_id;
2771: l_xpiv_rec.cnsld_ap_inv_id := r_cnsld_hdr.cnsld_ap_inv_id;
2772: l_xpiv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert
2773:
2774:
2775: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Creating External AP Invoice Header..');
2776:

Line 2866: l_xlpv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert

2862: l_xlpv_rec.attribute12 := r_cnsld_lns.attribute12;
2863: l_xlpv_rec.attribute13 := r_cnsld_lns.attribute13;
2864: l_xlpv_rec.attribute14 := r_cnsld_lns.attribute14;
2865: l_xlpv_rec.attribute15 := r_cnsld_lns.attribute15;
2866: l_xlpv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID ; -- 11-Dec-2007 cklee -- Fixed bug: 6682348 -- stamped request_id when insert
2867:
2868:
2869: -- Start of wraper code generated automatically by Debug code generator for okl_xtl_pay_invs_pub.insert_xtl_pay_invs
2870: IF(IS_DEBUG_PROCEDURE_ON) THEN