eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WORKFLOW_PKG dependencies on AP_APINV_APPROVERS

Line 1928: --Insert record into ap_apinv_approvers

1924: --END IF;
1925: /**************/
1926:
1927: --
1928: --Insert record into ap_apinv_approvers
1929: --
1930: INSERT INTO AP_APINV_APPROVERS(
1931: INVOICE_ID,
1932: INVOICE_ITERATION,

Line 1930: INSERT INTO AP_APINV_APPROVERS(

1926:
1927: --
1928: --Insert record into ap_apinv_approvers
1929: --
1930: INSERT INTO AP_APINV_APPROVERS(
1931: INVOICE_ID,
1932: INVOICE_ITERATION,
1933: INVOICE_KEY,
1934: LINE_NUMBER,

Line 2097: --Insert record into ap_apinv_approvers

2093: itemClassIn => l_next_approver.item_class,
2094: itemIdIn => l_next_approver.item_id);
2095: --END IF;
2096: /*********/
2097: --Insert record into ap_apinv_approvers
2098: INSERT INTO AP_APINV_APPROVERS(
2099: INVOICE_ID,
2100: INVOICE_ITERATION,
2101: INVOICE_KEY,

Line 2098: INSERT INTO AP_APINV_APPROVERS(

2094: itemIdIn => l_next_approver.item_id);
2095: --END IF;
2096: /*********/
2097: --Insert record into ap_apinv_approvers
2098: INSERT INTO AP_APINV_APPROVERS(
2099: INVOICE_ID,
2100: INVOICE_ITERATION,
2101: INVOICE_KEY,
2102: LINE_NUMBER,

Line 2240: FROM ap_apinv_approvers

2236: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2237:
2238: CURSOR Group_Approvers IS
2239: SELECT distinct role_name
2240: FROM ap_apinv_approvers
2241: WHERE notification_status = 'PEND'
2242: AND invoice_key = itemkey
2243: AND line_number IS NOT NULL;
2244:

Line 2317: FROM ap_apinv_approvers

2313: END IF;
2314:
2315: SELECT nvl(max(notification_iteration),0) + 1
2316: INTO l_not_iteration
2317: FROM ap_apinv_approvers
2318: WHERE invoice_key = itemkey;
2319:
2320: l_debug_info := 'Notification Iteration:'||l_not_iteration;
2321: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2327: l_debug_info := 'Update Iteration Value in ap_apinv_approvers';

2323: G_MODULE_NAME||l_api_name,
2324: l_debug_info);
2325: END IF;
2326:
2327: l_debug_info := 'Update Iteration Value in ap_apinv_approvers';
2328: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2329: FND_LOG.STRING(G_LEVEL_STATEMENT,
2330: G_MODULE_NAME||l_api_name,
2331: l_debug_info);

Line 2334: UPDATE ap_apinv_approvers

2330: G_MODULE_NAME||l_api_name,
2331: l_debug_info);
2332: END IF;
2333:
2334: UPDATE ap_apinv_approvers
2335: SET notification_iteration = l_not_iteration,
2336: notification_key = itemkey || '_' || l_not_iteration,
2337: child_process_item_key = itemkey || '_' || l_not_iteration,
2338: child_process_item_type = 'APINVAPR',

Line 2362: FROM ap_apinv_approvers

2358: SELECT SUM(DECODE(notification_status, 'SENT', 1, 0)),
2359: SUM(DECODE(notification_status, 'COMP', 1, 0))
2360: INTO l_sent,
2361: l_comp
2362: FROM ap_apinv_approvers
2363: WHERE invoice_key = itemkey
2364: GROUP BY invoice_key;
2365: EXCEPTION
2366: WHEN OTHERS THEN

Line 2410: l_debug_info := 'Cleanup ap_apinv_approvers';

2406: ,'NOT REQUIRED')
2407: WHERE Invoice_Id = l_invoice_id
2408: AND WFApproval_Status = 'INITIATED';
2409:
2410: l_debug_info := 'Cleanup ap_apinv_approvers';
2411: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2412: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2413: l_api_name,l_debug_info);
2414: END IF;

Line 2417: DELETE FROM AP_APINV_APPROVERS

2413: l_api_name,l_debug_info);
2414: END IF;
2415:
2416:
2417: DELETE FROM AP_APINV_APPROVERS
2418: WHERE Invoice_Id = l_invoice_id;
2419:
2420:
2421: l_debug_info := 'Set the Result to Finish';

Line 2457: FROM AP_APINV_APPROVERS

2453: SET WFApproval_Status = 'WFAPPROVED'
2454: WHERE Invoice_Id = l_invoice_id
2455: AND WFApproval_Status = 'INITIATED'
2456: AND Line_Number IN (SELECT DISTINCT Line_Number
2457: FROM AP_APINV_APPROVERS
2458: WHERE invoice_id = l_invoice_id
2459: AND Invoice_Iteration = l_iteration
2460: AND NOTIFICATION_STATUS = 'COMP');
2461:

Line 2473: l_debug_info := 'Clear the ap_apinv_approvers';

2469: SET WFApproval_Status = 'NOT REQUIRED'
2470: WHERE Invoice_Id = l_invoice_id
2471: AND WFApproval_Status = 'INITIATED';
2472:
2473: l_debug_info := 'Clear the ap_apinv_approvers';
2474: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2476: l_api_name,l_debug_info);
2477: END IF;

Line 2480: DELETE FROM AP_APINV_APPROVERS

2476: l_api_name,l_debug_info);
2477: END IF;
2478:
2479:
2480: DELETE FROM AP_APINV_APPROVERS
2481: WHERE Invoice_Id = l_invoice_id;
2482:
2483:
2484:

Line 2521: l_orig_system ap_apinv_approvers.orig_system%TYPE;

2517: l_invoice_description VARCHAR2(240);
2518: l_invoice_total NUMBER;
2519: l_invoice_currency_code VARCHAR2(15);
2520: l_role_name VARCHAR2(320);
2521: l_orig_system ap_apinv_approvers.orig_system%TYPE;
2522: l_orig_system_id number(15);
2523: l_invoice_iteration number;
2524: l_notification_iteration number;
2525: l_approver_name varchar2(360);

Line 2529: FROM ap_apinv_approvers

2525: l_approver_name varchar2(360);
2526:
2527: CURSOR Notif_Process IS
2528: SELECT distinct role_name
2529: FROM ap_apinv_approvers
2530: WHERE notification_status = 'PEND'
2531: AND invoice_key = itemKey
2532: AND line_number is NOT NULL
2533: AND notification_key IS NOT NULL;

Line 2673: FROM ap_apinv_approvers

2669: l_invoice_iteration,
2670: l_notification_iteration,
2671: l_orig_system,
2672: l_orig_system_id
2673: FROM ap_apinv_approvers
2674: WHERE role_name = Notif_Process_Rec.role_name
2675: AND notification_status = 'PEND'
2676: AND invoice_key = itemKey
2677: AND rownum = 1;

Line 2799: l_debug_info := 'Update the ap_apinv_approvers notification status';

2795: END IF;
2796:
2797: wf_engine.startProcess('APINVAPR', l_notification_key);
2798:
2799: l_debug_info := 'Update the ap_apinv_approvers notification status';
2800: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2802: l_api_name,l_debug_info);
2803: END IF;

Line 2805: UPDATE ap_apinv_approvers

2801: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
2802: l_api_name,l_debug_info);
2803: END IF;
2804:
2805: UPDATE ap_apinv_approvers
2806: SET notification_status = 'SENT'
2807: WHERE notification_key = l_notification_key;
2808:
2809: END IF;

Line 3200: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3196: --but I want to avoid another select on the table
3197: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3198: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3199: invap.Invoice_Key, al.line_number, al.amount
3200: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3201: WHERE invap.Notification_Key = itemkey
3202: AND al.line_number = invap.line_number
3203: AND al.invoice_id = invap.invoice_id;
3204:

Line 3210: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

3206: l_invoice_id NUMBER;
3207: l_level VARCHAR2(20);
3208: l_result VARCHAR2(20);
3209: l_invoice_key VARCHAR2(50);
3210: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3211: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3212: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3213: l_debug_info VARCHAR2(2000);
3214: l_user_id NUMBER(15);

Line 3211: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

3207: l_level VARCHAR2(20);
3208: l_result VARCHAR2(20);
3209: l_invoice_key VARCHAR2(50);
3210: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3211: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3212: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3213: l_debug_info VARCHAR2(2000);
3214: l_user_id NUMBER(15);
3215: l_login_id NUMBER(15);

Line 3212: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

3208: l_result VARCHAR2(20);
3209: l_invoice_key VARCHAR2(50);
3210: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3211: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3212: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3213: l_debug_info VARCHAR2(2000);
3214: l_user_id NUMBER(15);
3215: l_login_id NUMBER(15);
3216: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 3302: UPDATE AP_APINV_APPROVERS

3298: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3299: l_api_name,l_debug_info);
3300: END IF;
3301: --Update Approvers table
3302: UPDATE AP_APINV_APPROVERS
3303: SET Notification_status = 'COMP'
3304: WHERE Notification_Key = itemkey;
3305:
3306: fnd_client_info.set_org_context(l_org_id);

Line 3371: FROM ap_apinv_approvers

3367: ,Last_Update_Login = l_login_id
3368: WHERE invoice_id = l_invoice_id
3369: AND wfapproval_status <> 'MANUALLY APPROVED'
3370: AND line_number in (SELECT line_number
3371: FROM ap_apinv_approvers
3372: WHERE notification_key = itemkey);
3373: BEGIN
3374:
3375: SELECT invoice_key

Line 3377: FROM AP_APINV_APPROVERS

3373: BEGIN
3374:
3375: SELECT invoice_key
3376: INTO l_invoice_key
3377: FROM AP_APINV_APPROVERS
3378: WHERE Notification_Key = itemkey
3379: AND rownum = 1;
3380: EXCEPTION
3381: WHEN NO_DATA_FOUND THEN

Line 3382: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;

3378: WHERE Notification_Key = itemkey
3379: AND rownum = 1;
3380: EXCEPTION
3381: WHEN NO_DATA_FOUND THEN
3382: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
3383: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3384: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3385: l_api_name,l_debug_info);
3386: END IF;

Line 3428: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

3424: --but I want to avoid another select on the table
3425: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
3426: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
3427: invap.Invoice_Key, al.line_number, al.amount
3428: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
3429: WHERE invap.Notification_Key = itemkey
3430: AND al.line_number = invap.line_number
3431: AND al.invoice_id = invap.invoice_id;
3432:

Line 3438: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

3434: l_invoice_id NUMBER;
3435: l_level VARCHAR2(20);
3436: l_result VARCHAR2(20);
3437: l_invoice_key VARCHAR2(50);
3438: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3439: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3440: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3441: l_debug_info VARCHAR2(2000);
3442: l_user_id NUMBER(15);

Line 3439: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

3435: l_level VARCHAR2(20);
3436: l_result VARCHAR2(20);
3437: l_invoice_key VARCHAR2(50);
3438: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3439: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3440: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3441: l_debug_info VARCHAR2(2000);
3442: l_user_id NUMBER(15);
3443: l_login_id NUMBER(15);

Line 3440: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

3436: l_result VARCHAR2(20);
3437: l_invoice_key VARCHAR2(50);
3438: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3439: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3440: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3441: l_debug_info VARCHAR2(2000);
3442: l_user_id NUMBER(15);
3443: l_login_id NUMBER(15);
3444: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 3548: UPDATE AP_APINV_APPROVERS

3544: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3545: l_api_name,l_debug_info);
3546: END IF;
3547: --Update Approvers table
3548: UPDATE AP_APINV_APPROVERS
3549: SET Notification_status = 'COMP'
3550: WHERE Notification_Key = itemkey;
3551:
3552: fnd_client_info.set_org_context(l_org_id);

Line 3612: FROM AP_APINV_APPROVERS

3608: BEGIN
3609:
3610: SELECT invoice_key
3611: INTO l_invoice_key
3612: FROM AP_APINV_APPROVERS
3613: WHERE Notification_Key = itemkey
3614: AND rownum = 1;
3615: EXCEPTION
3616: WHEN NO_DATA_FOUND THEN

Line 3617: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;

3613: WHERE Notification_Key = itemkey
3614: AND rownum = 1;
3615: EXCEPTION
3616: WHEN NO_DATA_FOUND THEN
3617: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
3618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
3620: l_api_name,l_debug_info);
3621: END IF;

Line 3734: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

3730: l_invoice_id NUMBER;
3731: l_level VARCHAR2(20);
3732: l_result VARCHAR2(20);
3733: l_invoice_key VARCHAR2(50);
3734: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3735: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3736: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3737: l_debug_info VARCHAR2(2000);
3738: l_user_id NUMBER(15);

Line 3735: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

3731: l_level VARCHAR2(20);
3732: l_result VARCHAR2(20);
3733: l_invoice_key VARCHAR2(50);
3734: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3735: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3736: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3737: l_debug_info VARCHAR2(2000);
3738: l_user_id NUMBER(15);
3739: l_login_id NUMBER(15);

Line 3736: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

3732: l_result VARCHAR2(20);
3733: l_invoice_key VARCHAR2(50);
3734: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3735: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3736: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3737: l_debug_info VARCHAR2(2000);
3738: l_user_id NUMBER(15);
3739: l_login_id NUMBER(15);
3740: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 3911: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

3907: l_invoice_id NUMBER;
3908: l_level VARCHAR2(20);
3909: l_result VARCHAR2(20);
3910: l_invoice_key VARCHAR2(50);
3911: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3912: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3913: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3914: l_debug_info VARCHAR2(2000);
3915: l_user_id NUMBER(15);

Line 3912: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

3908: l_level VARCHAR2(20);
3909: l_result VARCHAR2(20);
3910: l_invoice_key VARCHAR2(50);
3911: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3912: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3913: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3914: l_debug_info VARCHAR2(2000);
3915: l_user_id NUMBER(15);
3916: l_login_id NUMBER(15);

Line 3913: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

3909: l_result VARCHAR2(20);
3910: l_invoice_key VARCHAR2(50);
3911: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
3912: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
3913: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
3914: l_debug_info VARCHAR2(2000);
3915: l_user_id NUMBER(15);
3916: l_login_id NUMBER(15);
3917: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 4065: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

4061: --but I want to avoid another select on the table
4062: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
4063: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
4064: invap.Invoice_Key, al.line_number, al.amount
4065: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
4066: WHERE invap.child_process_item_key = itemkey
4067: AND al.line_number = invap.line_number
4068: AND al.invoice_id = invap.invoice_id;
4069: l_api_name CONSTANT VARCHAR2(200) := 'aprvl_process_cancel_inv_sup';

Line 4073: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

4069: l_api_name CONSTANT VARCHAR2(200) := 'aprvl_process_cancel_inv_sup';
4070: l_invoice_id NUMBER;
4071: l_level VARCHAR2(20);
4072: l_invoice_key VARCHAR2(50);
4073: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
4074: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
4075: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4076: l_debug_info VARCHAR2(2000);
4077: l_user_id NUMBER(15);

Line 4074: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

4070: l_invoice_id NUMBER;
4071: l_level VARCHAR2(20);
4072: l_invoice_key VARCHAR2(50);
4073: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
4074: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
4075: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4076: l_debug_info VARCHAR2(2000);
4077: l_user_id NUMBER(15);
4078: l_login_id NUMBER(15);

Line 4075: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

4071: l_level VARCHAR2(20);
4072: l_invoice_key VARCHAR2(50);
4073: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
4074: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
4075: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
4076: l_debug_info VARCHAR2(2000);
4077: l_user_id NUMBER(15);
4078: l_login_id NUMBER(15);
4079: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 5124: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

5120: --Define cursor for lines affected by notification
5121: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
5122: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
5123: invap.Invoice_Key, al.line_number, al.amount
5124: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
5125: WHERE invap.Notification_Key = itemkey
5126: AND al.line_number = invap.line_number
5127: AND al.invoice_id = invap.invoice_id;
5128:

Line 5321: FROM AP_APINV_APPROVERS

5317: BEGIN
5318:
5319: SELECT invoice_key
5320: INTO l_invoice_key
5321: FROM AP_APINV_APPROVERS
5322: WHERE Notification_Key = itemkey
5323: AND rownum = 1;
5324: EXCEPTION
5325: WHEN NO_DATA_FOUND THEN

Line 5326: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;

5322: WHERE Notification_Key = itemkey
5323: AND rownum = 1;
5324: EXCEPTION
5325: WHEN NO_DATA_FOUND THEN
5326: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
5327: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5328: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
5329: l_api_name,l_debug_info);
5330: END IF;

Line 5403: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

5399: l_notf_receipient_type VARCHAR2(50);
5400: l_iteration NUMBER;
5401: l_notf_iteration NUMBER;
5402: l_invoice_key VARCHAR2(50);
5403: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5406: l_debug_info VARCHAR2(2000);
5407: l_line_number ap_invoice_lines_all.line_number%TYPE;

Line 5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

5400: l_iteration NUMBER;
5401: l_notf_iteration NUMBER;
5402: l_invoice_key VARCHAR2(50);
5403: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5406: l_debug_info VARCHAR2(2000);
5407: l_line_number ap_invoice_lines_all.line_number%TYPE;
5408: l_line_amount ap_invoice_lines_all.amount%TYPE;

Line 5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

5401: l_notf_iteration NUMBER;
5402: l_invoice_key VARCHAR2(50);
5403: l_role_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5404: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5405: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5406: l_debug_info VARCHAR2(2000);
5407: l_line_number ap_invoice_lines_all.line_number%TYPE;
5408: l_line_amount ap_invoice_lines_all.amount%TYPE;
5409: l_ext_person_id NUMBER(15);

Line 5836: FROM AP_APINV_APPROVERS

5832:
5833: --Define cursor for wf and ame records that need to be stopped
5834: CURSOR Item_Cur IS
5835: SELECT Item_Class, Item_Id, Role_Name, Invoice_Key, Notification_Key
5836: FROM AP_APINV_APPROVERS
5837: WHERE Invoice_ID = p_invoice_id
5838: AND NOTIFICATION_STATUS = 'SENT'
5839: GROUP BY Item_Class, Item_Id, Role_Name, Invoice_Key, Notification_Key
5840: ORDER BY Notification_Key;

Line 5844: FROM AP_APINV_APPROVERS

5840: ORDER BY Notification_Key;
5841:
5842: CURSOR Line_Item_Cur IS
5843: SELECT Item_Class, Item_Id, Role_Name, Invoice_Key, Notification_Key
5844: FROM AP_APINV_APPROVERS
5845: WHERE Invoice_ID = p_invoice_id
5846: AND Line_Number = p_line_number
5847: AND NOTIFICATION_STATUS = 'SENT'
5848: GROUP BY Item_Class, Item_Id, Role_Name, Invoice_Key, Notification_Key

Line 5852: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

5848: GROUP BY Item_Class, Item_Id, Role_Name, Invoice_Key, Notification_Key
5849: ORDER BY Notification_Key;
5850:
5851: l_api_name CONSTANT VARCHAR2(200) := 'Stop_Approval';
5852: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;

Line 5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

5849: ORDER BY Notification_Key;
5850:
5851: l_api_name CONSTANT VARCHAR2(200) := 'Stop_Approval';
5852: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;

Line 5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;

5851: l_api_name CONSTANT VARCHAR2(200) := 'Stop_Approval';
5852: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5858: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5859: l_debug_info VARCHAR2(2000);

Line 5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;

5852: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5858: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5859: l_debug_info VARCHAR2(2000);
5860: l_wf_exist BOOLEAN;

Line 5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;

5853: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5858: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5859: l_debug_info VARCHAR2(2000);
5860: l_wf_exist BOOLEAN;
5861: l_approval_iteration AP_INVOICES.approval_iteration%type;

Line 5858: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

5854: l_invoice_id NUMBER;
5855: l_invoice_key AP_APINV_APPROVERS.INVOICE_KEY%TYPE;
5856: l_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5857: l_old_not_key AP_APINV_APPROVERS.NOTIFICATION_KEY%TYPE;
5858: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
5859: l_debug_info VARCHAR2(2000);
5860: l_wf_exist BOOLEAN;
5861: l_approval_iteration AP_INVOICES.approval_iteration%type;
5862: l_end_date DATE;

Line 6004: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

6000: --but I want to avoid another select on the table
6001: CURSOR Items_Cur IS
6002: SELECT invap.Item_Class, invap.Item_Id, invap.Role_Name,
6003: invap.Invoice_Key, al.line_number, al.amount
6004: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
6005: WHERE invap.child_process_item_key = p_itemkey
6006: AND invap.line_number = p_line_number
6007: AND invap.invoice_id = p_invoice_id
6008: AND al.line_number = invap.line_number

Line 6018: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;

6014: l_invoice_id NUMBER;
6015: l_level VARCHAR2(20);
6016: l_result VARCHAR2(20);
6017: l_invoice_key VARCHAR2(50);
6018: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
6019: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
6020: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
6021: l_user_id NUMBER(15);
6022: l_login_id NUMBER(15);

Line 6019: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;

6015: l_level VARCHAR2(20);
6016: l_result VARCHAR2(20);
6017: l_invoice_key VARCHAR2(50);
6018: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
6019: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
6020: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
6021: l_user_id NUMBER(15);
6022: l_login_id NUMBER(15);
6023: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;

Line 6020: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;

6016: l_result VARCHAR2(20);
6017: l_invoice_key VARCHAR2(50);
6018: l_name AP_APINV_APPROVERS.ROLE_NAME%TYPE;
6019: l_item_class AP_APINV_APPROVERS.ITEM_CLASS%TYPE;
6020: l_item_id AP_APINV_APPROVERS.ITEM_ID%TYPE;
6021: l_user_id NUMBER(15);
6022: l_login_id NUMBER(15);
6023: l_hist_rec AP_INV_APRVL_HIST%ROWTYPE;
6024: l_approver_name VARCHAR2(150);

Line 6119: UPDATE AP_APINV_APPROVERS

6115: l_api_name,l_debug_info);
6116: END IF;
6117: --Update Approvers table
6118: IF l_response in ('APPROVED','REJECTED','ACCEPT') THEN
6119: UPDATE AP_APINV_APPROVERS
6120: SET Notification_status = 'COMP'
6121: WHERE CHILD_PROCESS_ITEM_KEY = p_itemkey
6122: AND INVOICE_ID = p_invoice_id
6123: AND LINE_NUMBER = p_line_number;

Line 6204: FROM AP_APINV_APPROVERS

6200: BEGIN
6201:
6202: SELECT invoice_key
6203: INTO l_invoice_key
6204: FROM AP_APINV_APPROVERS
6205: WHERE invoice_id = p_invoice_id
6206: AND line_number = p_line_number
6207: AND child_process_item_key = p_itemkey
6208: AND rownum = 1;

Line 6211: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;

6207: AND child_process_item_key = p_itemkey
6208: AND rownum = 1;
6209: EXCEPTION
6210: WHEN NO_DATA_FOUND THEN
6211: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
6212: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6213: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
6214: l_api_name,l_debug_info);
6215: END IF;

Line 6225: FROM AP_APINV_APPROVERS

6221: Initial Commit. so commenting it out here.
6222:
6223: SELECT count(*)
6224: INTO l_sent
6225: FROM AP_APINV_APPROVERS
6226: WHERE Notification_status = 'SENT'
6227: AND child_process_item_key = p_itemkey
6228: AND INVOICE_ID = p_invoice_id
6229: AND LINE_NUMBER = p_line_number;

Line 6720: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa

6716: END IF;
6717:
6718: SELECT COUNT(*)
6719: INTO l_num_lines_under_neg
6720: FROM ap_invoice_lines_all ail, ap_apinv_approvers aaa
6721: WHERE ail.invoice_id = p_invoice_id
6722: AND ail.org_id = p_org_id
6723: AND aaa.invoice_id = ail.invoice_id
6724: AND aaa.line_number = ail.line_number

Line 6981: -- from AP_APINV_APPROVERS

6977: WHERE invoice_distribution_id = l_next_approver.item_id;
6978:
6979: END IF; --l_class
6980: -- Bug 5590138. Modified table to AP_APPROVERS_LIST_GT
6981: -- from AP_APINV_APPROVERS
6982: --Insert record into ap_approvers_list_gt
6983: INSERT INTO AP_APPROVERS_LIST_GT(
6984: TRANSACTION_ID, -- Bug 5624200
6985: LINE_NUMBER,

Line 7104: DELETE FROM AP_APINV_APPROVERS;

7100: CLOSE key_Cur;
7101:
7102: --Clear all iaw processing records
7103:
7104: DELETE FROM AP_APINV_APPROVERS;
7105:
7106:
7107: --Set the lines status
7108: UPDATE ap_invoice_lines_all

Line 7148: FROM AP_APINV_APPROVERS

7144: l_api_name,l_debug_info);
7145: END IF;
7146: SELECT count(*)
7147: INTO l_sent
7148: FROM AP_APINV_APPROVERS
7149: WHERE Notification_status = 'SENT'
7150: AND child_process_item_key = p_itemkey
7151: AND invoice_id = p_invoice_id;
7152: IF l_sent = 0 THEN

Line 7164: FROM AP_APINV_APPROVERS

7160: BEGIN
7161:
7162: SELECT invoice_key
7163: INTO l_invoice_key
7164: FROM AP_APINV_APPROVERS
7165: WHERE Notification_Key = p_itemkey
7166: AND invoice_id = p_invoice_id
7167: AND rownum = 1;
7168: EXCEPTION

Line 7170: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;

7166: AND invoice_id = p_invoice_id
7167: AND rownum = 1;
7168: EXCEPTION
7169: WHEN NO_DATA_FOUND THEN
7170: l_debug_info := 'No Data Found in SELECT from AP_APINV_APPROVERS' ;
7171: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
7173: l_api_name,l_debug_info);
7174: END IF;

Line 7927: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al

7923:
7924:
7925: CURSOR Items_Cur(itemkey IN VARCHAR2) IS
7926: SELECT al.line_number, al.amount
7927: FROM AP_APINV_APPROVERS invap, AP_INVOICE_LINES_ALL al
7928: WHERE invap.Notification_Key = itemkey
7929: AND al.line_number = invap.line_number
7930: AND al.invoice_id = invap.invoice_id;
7931: BEGIN