DBA Data[Home] [Help]

APPS.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on FND_GLOBAL

Line 74: last_updated_by = fnd_global.user_id,

70: UPDATE ar_cmgt_credit_requests
71: SET trx_amount = nvl(p_credit_request_rec.trx_amount, trx_amount),
72: limit_amount = nvl(p_credit_request_rec.requested_amount, limit_amount),
73: requestor_id = nvl(p_credit_request_rec.requestor_id, requestor_id),
74: last_updated_by = fnd_global.user_id,
75: last_update_date = sysdate
76: WHERE credit_request_id = p_credit_request_rec.credit_request_id;
77:
78: -- Need to update the workflow attributes.

Line 191: last_updated_by = fnd_global.user_id,

187: UPDATE ar_cmgt_credit_requests
188: SET trx_amount = nvl(p_credit_request_rec.trx_amount, trx_amount),
189: limit_amount = nvl(p_credit_request_rec.requested_amount, limit_amount),
190: requestor_id = nvl(p_credit_request_rec.requestor_id, requestor_id),
191: last_updated_by = fnd_global.user_id,
192: last_update_date = sysdate,
193: review_type = nvl(p_credit_request_rec.review_type, review_type),
194: credit_classification = nvl(p_credit_request_rec.credit_classification, credit_classification),
195: limit_currency = nvl( p_credit_request_rec.requested_currency, limit_currency),

Line 601: last_updated_by = fnd_global.user_id,

597: END IF;
598: -- submit workflow
599: UPDATE ar_cmgt_credit_requests
600: SET status = 'SUBMIT',
601: last_updated_by = fnd_global.user_id,
602: last_update_date = sysdate
603: WHERE credit_request_id = p_credit_request_id;
604:
605: AR_CMGT_WF_ENGINE.START_WORKFLOW

Line 721: last_updated_by = fnd_global.user_id,

717: END IF;
718:
719: UPDATE ar_cmgt_credit_requests
720: SET status = 'SUBMIT',
721: last_updated_by = fnd_global.user_id,
722: last_update_date = sysdate
723: WHERE credit_request_id = cCreditRequestsRec.credit_request_id;
724:
725: AR_CMGT_WF_ENGINE.START_WORKFLOW