DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on FND_GLOBAL

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

842: l_tap_id_tbl.delete;
843: id_ind := 0;
844:
845: FOR cur_vendor_dtls IN c_vendor_dtls(cp_pph_id => l_disb_rec.pph_id) LOOP
846: IF NOT(cur_vendor_dtls.disbursement_basis = 'AMOUNT' AND SIGN(Fnd_Global.CONC_REQUEST_ID) = -1) THEN
847:
848: l_tapv_rec := l_tapv_rec_null;
849: l_tplv_rec := l_tplv_rec_null;
850:

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

1000: -- 05/31/07 ansethur changes for R12B Billing architecture Passthrough impacts ends
1001: l_tplv_rec.sel_id := l_disb_rec.sel_id;
1002: l_tplv_rec.line_number := 1;
1003:
1004: IF (SIGN(Fnd_Global.CONC_REQUEST_ID) <> -1) THEN
1005: l_tplv_rec.inv_distr_line_code := 'AUTO_DISBURSEMENT';
1006: END IF;
1007: l_tplv_rec.sty_id := l_disb_rec.passthru_stream_type_id;
1008:

Line 1083: ,last_updated_by = FND_GLOBAL.USER_ID

1079: FOR id_ind IN l_tap_id_tbl.first..l_tap_id_tbl.last LOOP
1080: update okl_trx_ap_invoices_b
1081: set TRX_STATUS_CODE = 'ERROR'
1082: ,object_version_number = object_version_number + 1
1083: ,last_updated_by = FND_GLOBAL.USER_ID
1084: ,last_update_date = sysdate
1085: ,last_update_login = FND_GLOBAL.LOGIN_ID
1086: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1087: where id = l_tap_id_tbl(id_ind);

Line 1085: ,last_update_login = FND_GLOBAL.LOGIN_ID

1081: set TRX_STATUS_CODE = 'ERROR'
1082: ,object_version_number = object_version_number + 1
1083: ,last_updated_by = FND_GLOBAL.USER_ID
1084: ,last_update_date = sysdate
1085: ,last_update_login = FND_GLOBAL.LOGIN_ID
1086: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1087: where id = l_tap_id_tbl(id_ind);
1088: END LOOP;
1089: END IF;

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

1082: ,object_version_number = object_version_number + 1
1083: ,last_updated_by = FND_GLOBAL.USER_ID
1084: ,last_update_date = sysdate
1085: ,last_update_login = FND_GLOBAL.LOGIN_ID
1086: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1087: where id = l_tap_id_tbl(id_ind);
1088: END LOOP;
1089: END IF;
1090:

Line 1120: Fnd_Global.USER_ID,

1116: VALUES
1117: (
1118: l_idh_id,
1119: 1,
1120: Fnd_Global.USER_ID,
1121: SYSDATE,
1122: Fnd_Global.USER_ID,
1123: SYSDATE,
1124: Fnd_Global.LOGIN_ID,

Line 1122: Fnd_Global.USER_ID,

1118: l_idh_id,
1119: 1,
1120: Fnd_Global.USER_ID,
1121: SYSDATE,
1122: Fnd_Global.USER_ID,
1123: SYSDATE,
1124: Fnd_Global.LOGIN_ID,
1125: null, --inv_lease_k_rec.Investor_Agreement_id,
1126: null, --share_rec.TOP_LINE_ID,

Line 1124: Fnd_Global.LOGIN_ID,

1120: Fnd_Global.USER_ID,
1121: SYSDATE,
1122: Fnd_Global.USER_ID,
1123: SYSDATE,
1124: Fnd_Global.LOGIN_ID,
1125: null, --inv_lease_k_rec.Investor_Agreement_id,
1126: null, --share_rec.TOP_LINE_ID,
1127: --rkuttiya R12 B Billing Architecture commented out following
1128: -- l_lsm_rcpt_tbl(lsm_rcpt_id_ind).lsm_id,

Line 1467: ,last_updated_by = FND_GLOBAL.USER_ID

1463: IF NVL(l_return_status, 'E') = OKL_API.G_RET_STS_SUCCESS THEN
1464: update okl_strm_elements
1465: set date_disbursed = trunc(sysdate)
1466: ,object_version_number = object_version_number + 1
1467: ,last_updated_by = FND_GLOBAL.USER_ID
1468: ,last_update_date = sysdate
1469: ,last_update_login = FND_GLOBAL.LOGIN_ID
1470: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1471: where id = l_disb_rec.sel_id;

Line 1469: ,last_update_login = FND_GLOBAL.LOGIN_ID

1465: set date_disbursed = trunc(sysdate)
1466: ,object_version_number = object_version_number + 1
1467: ,last_updated_by = FND_GLOBAL.USER_ID
1468: ,last_update_date = sysdate
1469: ,last_update_login = FND_GLOBAL.LOGIN_ID
1470: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1471: where id = l_disb_rec.sel_id;
1472: END IF;
1473: END IF;

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

1466: ,object_version_number = object_version_number + 1
1467: ,last_updated_by = FND_GLOBAL.USER_ID
1468: ,last_update_date = sysdate
1469: ,last_update_login = FND_GLOBAL.LOGIN_ID
1470: ,request_id = NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),null)
1471: where id = l_disb_rec.sel_id;
1472: END IF;
1473: END IF;
1474: