[Home] [Help]
18: X_Match_Mode IN VARCHAR2,
19: X_Match_Quantity IN NUMBER,
20: X_Match_Amount IN NUMBER,
21: X_Unit_Price IN NUMBER,
22: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
23: X_Calling_Sequence IN VARCHAR2);
24:
25:
26: PROCEDURE Get_Total_Proration_Quantity(
52:
53: PROCEDURE Insert_Invoice_Distributions (
54: X_Invoice_ID IN NUMBER,
55: X_Invoice_Line_Number IN NUMBER,
56: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
57: X_Rcv_Transaction_Id IN NUMBER,
58: X_Total_Amount IN NUMBER,
59: X_Calling_Sequence IN VARCHAR2);
60:
59: X_Calling_Sequence IN VARCHAR2);
60:
61:
62: Procedure Update_PO_Shipments_Dists(
63: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.Dist_Tab_Type,
64: X_Po_Line_Location_Id IN NUMBER,
65: X_Match_Amount IN NUMBER,
66: X_Match_Quantity IN NUMBER,
67: X_Uom_Lookup_Code IN VARCHAR2,
92: PROCEDURE Get_Corr_Dist_Proration_Info(
93: X_Corrected_Invoice_Id IN NUMBER,
94: X_Corrected_Line_Number IN NUMBER,
95: X_Corr_Dist_Tab IN OUT NOCOPY
96: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
97: X_Correction_Type IN VARCHAR2,
98: X_Correction_Amount IN NUMBER,
99: X_Correction_Quantity IN NUMBER,
100: X_Correction_Price IN NUMBER,
120: X_Invoice_Id IN NUMBER,
121: X_Invoice_Line_Number IN NUMBER,
122: X_Corrected_Invoice_id IN NUMBER,
123: X_Corr_Dist_Tab IN OUT NOCOPY
124: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
125: X_Correction_Type IN VARCHAR2,
126: X_Total_Amount IN NUMBER,
127: X_Calling_Sequence IN VARCHAR2);
128:
127: X_Calling_Sequence IN VARCHAR2);
128:
129:
130: PROCEDURE Update_Corr_Po_Shipments_Dists(
131: X_Corr_Dist_Tab IN AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
132: X_Po_Line_Location_Id IN NUMBER,
133: X_Quantity IN NUMBER,
134: X_Amount IN NUMBER,
135: X_Correction_Type IN VARCHAR2,
232: X_invoice_id IN NUMBER,
233: X_invoice_line_number IN NUMBER,
234: X_Po_Line_Location_id IN NUMBER,
235: X_rcv_transaction_id IN NUMBER,
236: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
237: X_amount IN NUMBER,
238: X_quantity IN NUMBER,
239: X_unit_price IN NUMBER,
240: X_uom_lookup_code IN VARCHAR2,
285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Base_Credit_Rcv_Match(+)');
286: END IF;
287:
288: -- Update the calling sequence (for error message).
289: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_rcv_match<-'||X_calling_sequence;
290:
291: l_debug_info := 'Get Invoice and System Options information';
292: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
971: X_Match_Quantity IN NUMBER,
972: X_Match_Amount IN NUMBER,
973: X_Unit_Price IN NUMBER,
974: X_Dist_Tab IN OUT NOCOPY
975: AP_MATCHING_PKG.DIST_TAB_TYPE,
976: X_Calling_Sequence IN VARCHAR2) IS
977:
978: --Modified below cursor for bug #7015553 to receive projec_id and task_id
979: --values from receivables tables if these are different in PO and receipt.
1531: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1532: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1533: END IF;
1534: -- Bug 5465722
1535: ap_matching_pkg.build_prepay_account(
1536: P_base_ccid => x_dist_tab(i).po_ccid,
1537: P_overlay_ccid => g_prepay_ccid,
1538: P_accounting_date => g_line_accounting_date,
1539: P_result_Ccid => l_dist_ccid,
2511:
2512: PROCEDURE Insert_Invoice_Distributions (X_Invoice_ID IN NUMBER,
2513: X_Invoice_Line_Number IN NUMBER,
2514: X_Dist_Tab IN OUT NOCOPY
2515: AP_MATCHING_PKG.Dist_Tab_Type,
2516: X_Rcv_Transaction_Id IN NUMBER,
2517: X_Total_Amount IN NUMBER,
2518: X_Calling_Sequence IN VARCHAR2) IS
2519:
2937: END Insert_Invoice_Distributions;
2938:
2939:
2940: Procedure Update_PO_Shipments_Dists(
2941: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.Dist_Tab_Type,
2942: X_Po_Line_Location_Id IN NUMBER,
2943: X_Match_Amount IN NUMBER,
2944: X_Match_Quantity IN NUMBER,
2945: X_Uom_Lookup_Code IN VARCHAR2,
3272: X_Match_Mode IN VARCHAR2,
3273: X_Po_Line_Location_Id IN NUMBER,
3274: X_Rcv_Transaction_Id IN NUMBER,
3275: x_CORR_dIST_tAB IN OUT NOCOPY
3276: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
3277: X_Uom_Lookup_Code IN VARCHAR2,
3278: X_Retained_Amount IN NUMBER DEFAULT NULL,
3279: X_Calling_Sequence IN VARCHAR2) IS
3280:
3531: PROCEDURE Get_Corr_Dist_Proration_Info(
3532: x_corrected_invoice_id IN NUMBER,
3533: x_corrected_line_number IN NUMBER,
3534: x_corr_dist_tab IN OUT NOCOPY
3535: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
3536: x_correction_type IN VARCHAR2,
3537: x_correction_amount IN NUMBER,
3538: x_correction_quantity IN NUMBER,
3539: x_correction_price IN NUMBER,
3834:
3835:
3836:
3837: PROCEDURE Update_Corr_Po_Shipments_Dists(
3838: X_Corr_Dist_Tab IN AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
3839: X_Po_Line_Location_Id IN NUMBER,
3840: X_Quantity IN NUMBER,
3841: X_Amount IN NUMBER,
3842: X_Correction_Type IN VARCHAR2,
3858:
3859: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
3860:
3861: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3862: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');
3863: END IF;
3864:
3865: l_debug_info := 'Create l_po_ap_dist_rec object';
3866: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3963: X_Msg_Data => l_msg_data);
3964:
3965:
3966: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3967: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');
3968: END IF;
3969:
3970:
3971: EXCEPTION
4354: PROCEDURE Insert_Corr_Invoice_Dists(x_invoice_id IN NUMBER,
4355: x_invoice_line_number IN NUMBER,
4356: x_corrected_invoice_id IN NUMBER,
4357: x_corr_dist_tab IN OUT NOCOPY
4358: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
4359: x_correction_type IN VARCHAR2,
4360: x_total_amount IN NUMBER,
4361: x_calling_sequence IN VARCHAR2) IS
4362: