DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on FND_GLOBAL

Line 891: IF NOT(cur_vendor_dtls.disbursement_basis = 'AMOUNT' AND SIGN(Fnd_Global.CONC_REQUEST_ID) = -1) THEN

887: l_tap_id_tbl.delete;
888: id_ind := 0;
889:
890: FOR cur_vendor_dtls IN c_vendor_dtls(cp_pph_id => l_disb_rec.pph_id) LOOP
891: IF NOT(cur_vendor_dtls.disbursement_basis = 'AMOUNT' AND SIGN(Fnd_Global.CONC_REQUEST_ID) = -1) THEN
892:
893: l_tapv_rec := l_tapv_rec_null;
894: l_tplv_rec := l_tplv_rec_null;
895:

Line 1051: IF (SIGN(Fnd_Global.CONC_REQUEST_ID) <> -1) THEN

1047: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts ends
1048: l_tplv_rec.sel_id := l_disb_rec.sel_id;
1049: l_tplv_rec.line_number := 1;
1050:
1051: IF (SIGN(Fnd_Global.CONC_REQUEST_ID) <> -1) THEN
1052: l_tplv_rec.inv_distr_line_code := 'AUTO_DISBURSEMENT';
1053: END IF;
1054: l_tplv_rec.sty_id := l_disb_rec.passthru_stream_type_id;
1055:

Line 1130: ,last_updated_by = FND_GLOBAL.USER_ID

1126: FOR id_ind IN l_tap_id_tbl.first..l_tap_id_tbl.last LOOP
1127: update okl_trx_ap_invoices_b
1128: set TRX_STATUS_CODE = 'ERROR'
1129: ,object_version_number = object_version_number + 1
1130: ,last_updated_by = FND_GLOBAL.USER_ID
1131: ,last_update_date = sysdate
1132: ,last_update_login = FND_GLOBAL.LOGIN_ID
1133: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1134: where id = l_tap_id_tbl(id_ind);

Line 1132: ,last_update_login = FND_GLOBAL.LOGIN_ID

1128: set TRX_STATUS_CODE = 'ERROR'
1129: ,object_version_number = object_version_number + 1
1130: ,last_updated_by = FND_GLOBAL.USER_ID
1131: ,last_update_date = sysdate
1132: ,last_update_login = FND_GLOBAL.LOGIN_ID
1133: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1134: where id = l_tap_id_tbl(id_ind);
1135: END LOOP;
1136: END IF;

Line 1133: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)

1129: ,object_version_number = object_version_number + 1
1130: ,last_updated_by = FND_GLOBAL.USER_ID
1131: ,last_update_date = sysdate
1132: ,last_update_login = FND_GLOBAL.LOGIN_ID
1133: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1134: where id = l_tap_id_tbl(id_ind);
1135: END LOOP;
1136: END IF;
1137:

Line 1169: Fnd_Global.USER_ID,

1165: VALUES
1166: (
1167: l_idh_id,
1168: 1,
1169: Fnd_Global.USER_ID,
1170: SYSDATE,
1171: Fnd_Global.USER_ID,
1172: SYSDATE,
1173: Fnd_Global.LOGIN_ID,

Line 1171: Fnd_Global.USER_ID,

1167: l_idh_id,
1168: 1,
1169: Fnd_Global.USER_ID,
1170: SYSDATE,
1171: Fnd_Global.USER_ID,
1172: SYSDATE,
1173: Fnd_Global.LOGIN_ID,
1174: null, --inv_lease_k_rec.Investor_Agreement_id,
1175: null, --share_rec.TOP_LINE_ID,

Line 1173: Fnd_Global.LOGIN_ID,

1169: Fnd_Global.USER_ID,
1170: SYSDATE,
1171: Fnd_Global.USER_ID,
1172: SYSDATE,
1173: Fnd_Global.LOGIN_ID,
1174: null, --inv_lease_k_rec.Investor_Agreement_id,
1175: null, --share_rec.TOP_LINE_ID,
1176: --rkuttiya R12 B Billing Architecture commented out following
1177: -- l_lsm_rcpt_tbl(lsm_rcpt_id_ind).lsm_id,

Line 1517: ,last_updated_by = FND_GLOBAL.USER_ID

1513: IF NVL(l_return_status, 'E') = OKL_API.G_RET_STS_SUCCESS THEN
1514: update okl_strm_elements
1515: set date_disbursed = trunc(sysdate)
1516: ,object_version_number = object_version_number + 1
1517: ,last_updated_by = FND_GLOBAL.USER_ID
1518: ,last_update_date = sysdate
1519: ,last_update_login = FND_GLOBAL.LOGIN_ID
1520: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1521: where id = l_disb_rec.sel_id;

Line 1519: ,last_update_login = FND_GLOBAL.LOGIN_ID

1515: set date_disbursed = trunc(sysdate)
1516: ,object_version_number = object_version_number + 1
1517: ,last_updated_by = FND_GLOBAL.USER_ID
1518: ,last_update_date = sysdate
1519: ,last_update_login = FND_GLOBAL.LOGIN_ID
1520: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1521: where id = l_disb_rec.sel_id;
1522: END IF;
1523: END IF;

Line 1520: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)

1516: ,object_version_number = object_version_number + 1
1517: ,last_updated_by = FND_GLOBAL.USER_ID
1518: ,last_update_date = sysdate
1519: ,last_update_login = FND_GLOBAL.LOGIN_ID
1520: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1521: where id = l_disb_rec.sel_id;
1522: END IF;
1523: END IF;
1524: