APPS.CN_PAY_APPROVAL_FLOW_PKG dependencies on CN_PAY_APPROVAL_FLOW

Line 1: PACKAGE BODY CN_PAY_APPROVAL_FLOW_PKG AS

1: PACKAGE BODY CN_PAY_APPROVAL_FLOW_PKG AS
2: /* $Header: cntpflwb.pls 120.1 2005/08/29 15:41:17 fmburu noship $*/
3:
4:
5: -- * -------------------------------------------------------------------------*

Line 20: INSERT into CN_PAY_APPROVAL_FLOW

16: ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_PAY_APPROVAL_FLOW
21: ( PAY_APPROVAL_FLOW_ID,
22: PAYRUN_ID,
23: PAYMENT_WORKSHEET_ID,
24: SUBMIT_BY_RESOURCE_ID,

Line 138: UPDATE CN_PAY_APPROVAL_FLOW oldrec

134: ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS
135:
136: BEGIN
137:
138: UPDATE CN_PAY_APPROVAL_FLOW oldrec
139: SET
140: PAYRUN_ID = DECODE(p_pay_approval_flow_rec.PAYRUN_ID,
141: FND_API.G_MISS_NUM,
142: NULL,

Line 325: FROM CN_PAY_APPROVAL_FLOW

321: ( p_pay_approval_flow_rec IN PAY_APPROVAL_FLOW_REC_TYPE) IS
322:
323: CURSOR c IS
324: SELECT object_version_number
325: FROM CN_PAY_APPROVAL_FLOW
326: WHERE pay_approval_flow_id = p_pay_approval_flow_rec.pay_approval_flow_id;
327:
328: tlinfo c%ROWTYPE ;
329: BEGIN

Line 346: UPDATE CN_PAY_APPROVAL_FLOW oldrec

342: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
343: fnd_msg_pub.add;
344: raise fnd_api.g_exc_unexpected_error;
345: end if;
346: UPDATE CN_PAY_APPROVAL_FLOW oldrec
347: SET
348: PAYRUN_ID = DECODE(p_pay_approval_flow_rec.PAYRUN_ID,
349: FND_API.G_MISS_NUM,
350: NULL,

Line 533: DELETE FROM CN_PAY_APPROVAL_FLOW

529: ) IS
530:
531: BEGIN
532:
533: DELETE FROM CN_PAY_APPROVAL_FLOW
534: WHERE pay_approval_flow_id = p_pay_approval_flow_id;
535:
536: IF (SQL%ROWCOUNT=0) THEN
537: RAISE NO_DATA_FOUND;

Line 543: END CN_PAY_APPROVAL_FLOW_PKG;

539:
540: END Delete_row;
541:
542:
543: END CN_PAY_APPROVAL_FLOW_PKG;