251: ,l_org_id
252: ,'N'
253: ,l_related_prepay_app_event_id
254: ,l_transaction_type
255: ,FND_GLOBAL.user_id
256: ,sysdate
257: ,FND_GLOBAL.login_id
258: ,FND_GLOBAL.user_id
259: ,sysdate
253: ,l_related_prepay_app_event_id
254: ,l_transaction_type
255: ,FND_GLOBAL.user_id
256: ,sysdate
257: ,FND_GLOBAL.login_id
258: ,FND_GLOBAL.user_id
259: ,sysdate
260: ,null
261: ,null
254: ,l_transaction_type
255: ,FND_GLOBAL.user_id
256: ,sysdate
257: ,FND_GLOBAL.login_id
258: ,FND_GLOBAL.user_id
259: ,sysdate
260: ,null
261: ,null
262: ,null
2055: APAD.Quantity_Variance,
2056: APAD.Invoice_Base_Qty_Variance,
2057: APAD.Amount_Variance,
2058: APAD.Invoice_Base_Amt_Variance,
2059: FND_GLOBAL.User_ID,
2060: SYSDATE,
2061: SYSDATE,
2062: FND_GLOBAL.User_ID,
2063: FND_GLOBAL.User_ID,
2058: APAD.Invoice_Base_Amt_Variance,
2059: FND_GLOBAL.User_ID,
2060: SYSDATE,
2061: SYSDATE,
2062: FND_GLOBAL.User_ID,
2063: FND_GLOBAL.User_ID,
2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2059: FND_GLOBAL.User_ID,
2060: SYSDATE,
2061: SYSDATE,
2062: FND_GLOBAL.User_ID,
2063: FND_GLOBAL.User_ID,
2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2067: FND_GLOBAL.Conc_Request_ID
2060: SYSDATE,
2061: SYSDATE,
2062: FND_GLOBAL.User_ID,
2063: FND_GLOBAL.User_ID,
2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2067: FND_GLOBAL.Conc_Request_ID
2068: FROM AP_Prepay_App_Dists APAD
2061: SYSDATE,
2062: FND_GLOBAL.User_ID,
2063: FND_GLOBAL.User_ID,
2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2067: FND_GLOBAL.Conc_Request_ID
2068: FROM AP_Prepay_App_Dists APAD
2069: WHERE Prepay_App_Distribution_ID = P_Prepay_Reversal_ID;
2063: FND_GLOBAL.User_ID,
2064: FND_GLOBAL.Prog_Appl_ID,
2065: FND_GLOBAL.Conc_Program_ID,
2066: SYSDATE,
2067: FND_GLOBAL.Conc_Request_ID
2068: FROM AP_Prepay_App_Dists APAD
2069: WHERE Prepay_App_Distribution_ID = P_Prepay_Reversal_ID;
2070:
2071: ELSIF p_inv_reversal_id IS NOT NULL THEN
2134: APAD.Quantity_Variance,
2135: APAD.Invoice_Base_Qty_Variance,
2136: APAD.Amount_Variance,
2137: APAD.Invoice_Base_Amt_Variance,
2138: FND_GLOBAL.User_ID,
2139: SYSDATE,
2140: SYSDATE,
2141: FND_GLOBAL.User_ID,
2142: FND_GLOBAL.User_ID,
2137: APAD.Invoice_Base_Amt_Variance,
2138: FND_GLOBAL.User_ID,
2139: SYSDATE,
2140: SYSDATE,
2141: FND_GLOBAL.User_ID,
2142: FND_GLOBAL.User_ID,
2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2138: FND_GLOBAL.User_ID,
2139: SYSDATE,
2140: SYSDATE,
2141: FND_GLOBAL.User_ID,
2142: FND_GLOBAL.User_ID,
2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2146: FND_GLOBAL.Conc_Request_ID
2139: SYSDATE,
2140: SYSDATE,
2141: FND_GLOBAL.User_ID,
2142: FND_GLOBAL.User_ID,
2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2146: FND_GLOBAL.Conc_Request_ID
2147: FROM AP_Prepay_App_Dists APAD
2140: SYSDATE,
2141: FND_GLOBAL.User_ID,
2142: FND_GLOBAL.User_ID,
2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2146: FND_GLOBAL.Conc_Request_ID
2147: FROM AP_Prepay_App_Dists APAD
2148: WHERE Invoice_Distribution_ID = P_Inv_Reversal_ID;
2142: FND_GLOBAL.User_ID,
2143: FND_GLOBAL.Prog_Appl_ID,
2144: FND_GLOBAL.Conc_Program_ID,
2145: SYSDATE,
2146: FND_GLOBAL.Conc_Request_ID
2147: FROM AP_Prepay_App_Dists APAD
2148: WHERE Invoice_Distribution_ID = P_Inv_Reversal_ID;
2149:
2150: END IF;
2262: P_PAD_Rec.Quantity_Variance,
2263: P_PAD_Rec.Invoice_Base_Qty_Variance,
2264: P_PAD_Rec.Amount_Variance,
2265: P_PAD_Rec.Invoice_Base_Amt_Variance,
2266: FND_GLOBAL.User_ID,
2267: SYSDATE,
2268: SYSDATE,
2269: FND_GLOBAL.User_ID,
2270: FND_GLOBAL.User_ID,
2265: P_PAD_Rec.Invoice_Base_Amt_Variance,
2266: FND_GLOBAL.User_ID,
2267: SYSDATE,
2268: SYSDATE,
2269: FND_GLOBAL.User_ID,
2270: FND_GLOBAL.User_ID,
2271: FND_GLOBAL.Prog_Appl_ID,
2272: FND_GLOBAL.Conc_Program_ID,
2273: SYSDATE,
2266: FND_GLOBAL.User_ID,
2267: SYSDATE,
2268: SYSDATE,
2269: FND_GLOBAL.User_ID,
2270: FND_GLOBAL.User_ID,
2271: FND_GLOBAL.Prog_Appl_ID,
2272: FND_GLOBAL.Conc_Program_ID,
2273: SYSDATE,
2274: FND_GLOBAL.Conc_Request_ID
2267: SYSDATE,
2268: SYSDATE,
2269: FND_GLOBAL.User_ID,
2270: FND_GLOBAL.User_ID,
2271: FND_GLOBAL.Prog_Appl_ID,
2272: FND_GLOBAL.Conc_Program_ID,
2273: SYSDATE,
2274: FND_GLOBAL.Conc_Request_ID
2275: );
2268: SYSDATE,
2269: FND_GLOBAL.User_ID,
2270: FND_GLOBAL.User_ID,
2271: FND_GLOBAL.Prog_Appl_ID,
2272: FND_GLOBAL.Conc_Program_ID,
2273: SYSDATE,
2274: FND_GLOBAL.Conc_Request_ID
2275: );
2276:
2270: FND_GLOBAL.User_ID,
2271: FND_GLOBAL.Prog_Appl_ID,
2272: FND_GLOBAL.Conc_Program_ID,
2273: SYSDATE,
2274: FND_GLOBAL.Conc_Request_ID
2275: );
2276:
2277: -- Logging Infra: Procedure level
2278: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN