387: ,l_org_id
388: ,'N'
389: ,l_related_prepay_app_event_id
390: ,l_transaction_type
391: ,FND_GLOBAL.user_id
392: ,sysdate
393: ,FND_GLOBAL.login_id
394: ,FND_GLOBAL.user_id
395: ,sysdate
389: ,l_related_prepay_app_event_id
390: ,l_transaction_type
391: ,FND_GLOBAL.user_id
392: ,sysdate
393: ,FND_GLOBAL.login_id
394: ,FND_GLOBAL.user_id
395: ,sysdate
396: ,null
397: ,null
390: ,l_transaction_type
391: ,FND_GLOBAL.user_id
392: ,sysdate
393: ,FND_GLOBAL.login_id
394: ,FND_GLOBAL.user_id
395: ,sysdate
396: ,null
397: ,null
398: ,null
2730: APAD.Quantity_Variance,
2731: APAD.Invoice_Base_Qty_Variance,
2732: APAD.Amount_Variance,
2733: APAD.Invoice_Base_Amt_Variance,
2734: FND_GLOBAL.User_ID,
2735: SYSDATE,
2736: SYSDATE,
2737: FND_GLOBAL.User_ID,
2738: FND_GLOBAL.User_ID,
2733: APAD.Invoice_Base_Amt_Variance,
2734: FND_GLOBAL.User_ID,
2735: SYSDATE,
2736: SYSDATE,
2737: FND_GLOBAL.User_ID,
2738: FND_GLOBAL.User_ID,
2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2734: FND_GLOBAL.User_ID,
2735: SYSDATE,
2736: SYSDATE,
2737: FND_GLOBAL.User_ID,
2738: FND_GLOBAL.User_ID,
2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2742: FND_GLOBAL.Conc_Request_ID
2735: SYSDATE,
2736: SYSDATE,
2737: FND_GLOBAL.User_ID,
2738: FND_GLOBAL.User_ID,
2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2742: FND_GLOBAL.Conc_Request_ID
2743: FROM AP_Prepay_App_Dists APAD,
2736: SYSDATE,
2737: FND_GLOBAL.User_ID,
2738: FND_GLOBAL.User_ID,
2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2742: FND_GLOBAL.Conc_Request_ID
2743: FROM AP_Prepay_App_Dists APAD,
2744: ap_prepay_history_all aph, --Bug 9112240
2738: FND_GLOBAL.User_ID,
2739: FND_GLOBAL.Prog_Appl_ID,
2740: FND_GLOBAL.Conc_Program_ID,
2741: SYSDATE,
2742: FND_GLOBAL.Conc_Request_ID
2743: FROM AP_Prepay_App_Dists APAD,
2744: ap_prepay_history_all aph, --Bug 9112240
2745: ap_prepay_history_all aphr,
2746: xla_events xer
2816: APAD.Quantity_Variance,
2817: APAD.Invoice_Base_Qty_Variance,
2818: APAD.Amount_Variance,
2819: APAD.Invoice_Base_Amt_Variance,
2820: FND_GLOBAL.User_ID,
2821: SYSDATE,
2822: SYSDATE,
2823: FND_GLOBAL.User_ID,
2824: FND_GLOBAL.User_ID,
2819: APAD.Invoice_Base_Amt_Variance,
2820: FND_GLOBAL.User_ID,
2821: SYSDATE,
2822: SYSDATE,
2823: FND_GLOBAL.User_ID,
2824: FND_GLOBAL.User_ID,
2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2820: FND_GLOBAL.User_ID,
2821: SYSDATE,
2822: SYSDATE,
2823: FND_GLOBAL.User_ID,
2824: FND_GLOBAL.User_ID,
2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2828: FND_GLOBAL.Conc_Request_ID
2821: SYSDATE,
2822: SYSDATE,
2823: FND_GLOBAL.User_ID,
2824: FND_GLOBAL.User_ID,
2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2828: FND_GLOBAL.Conc_Request_ID
2829: FROM AP_Prepay_App_Dists APAD,
2822: SYSDATE,
2823: FND_GLOBAL.User_ID,
2824: FND_GLOBAL.User_ID,
2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2828: FND_GLOBAL.Conc_Request_ID
2829: FROM AP_Prepay_App_Dists APAD,
2830: ap_prepay_history_all aph --Bug 9112240
2824: FND_GLOBAL.User_ID,
2825: FND_GLOBAL.Prog_Appl_ID,
2826: FND_GLOBAL.Conc_Program_ID,
2827: SYSDATE,
2828: FND_GLOBAL.Conc_Request_ID
2829: FROM AP_Prepay_App_Dists APAD,
2830: ap_prepay_history_all aph --Bug 9112240
2831: WHERE apad.prepay_history_id = aph.prepay_history_id --Bug 9112240
2832: AND APAD.Prepay_App_Distribution_ID = nvl(p_prepay_inv_dist_id,APAD.Prepay_App_Distribution_ID) --7686421
2950: P_PAD_Rec.Quantity_Variance,
2951: P_PAD_Rec.Invoice_Base_Qty_Variance,
2952: P_PAD_Rec.Amount_Variance,
2953: P_PAD_Rec.Invoice_Base_Amt_Variance,
2954: FND_GLOBAL.User_ID,
2955: SYSDATE,
2956: SYSDATE,
2957: FND_GLOBAL.User_ID,
2958: FND_GLOBAL.User_ID,
2953: P_PAD_Rec.Invoice_Base_Amt_Variance,
2954: FND_GLOBAL.User_ID,
2955: SYSDATE,
2956: SYSDATE,
2957: FND_GLOBAL.User_ID,
2958: FND_GLOBAL.User_ID,
2959: FND_GLOBAL.Prog_Appl_ID,
2960: FND_GLOBAL.Conc_Program_ID,
2961: SYSDATE,
2954: FND_GLOBAL.User_ID,
2955: SYSDATE,
2956: SYSDATE,
2957: FND_GLOBAL.User_ID,
2958: FND_GLOBAL.User_ID,
2959: FND_GLOBAL.Prog_Appl_ID,
2960: FND_GLOBAL.Conc_Program_ID,
2961: SYSDATE,
2962: FND_GLOBAL.Conc_Request_ID
2955: SYSDATE,
2956: SYSDATE,
2957: FND_GLOBAL.User_ID,
2958: FND_GLOBAL.User_ID,
2959: FND_GLOBAL.Prog_Appl_ID,
2960: FND_GLOBAL.Conc_Program_ID,
2961: SYSDATE,
2962: FND_GLOBAL.Conc_Request_ID
2963: );
2956: SYSDATE,
2957: FND_GLOBAL.User_ID,
2958: FND_GLOBAL.User_ID,
2959: FND_GLOBAL.Prog_Appl_ID,
2960: FND_GLOBAL.Conc_Program_ID,
2961: SYSDATE,
2962: FND_GLOBAL.Conc_Request_ID
2963: );
2964:
2958: FND_GLOBAL.User_ID,
2959: FND_GLOBAL.Prog_Appl_ID,
2960: FND_GLOBAL.Conc_Program_ID,
2961: SYSDATE,
2962: FND_GLOBAL.Conc_Request_ID
2963: );
2964:
2965: -- Logging Infra: Procedure level
2966: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN