[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,
234: X_invoice_id IN NUMBER,
235: X_invoice_line_number IN NUMBER,
236: X_Po_Line_Location_id IN NUMBER,
237: X_rcv_transaction_id IN NUMBER,
238: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.DIST_TAB_TYPE,
239: X_amount IN NUMBER,
240: X_quantity IN NUMBER,
241: X_unit_price IN NUMBER,
242: X_uom_lookup_code IN VARCHAR2,
297: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_RECT_MATCH_PKG.Base_Credit_Rcv_Match(+)');
298: END IF;
299:
300: -- Update the calling sequence (for error message).
301: current_calling_sequence := 'AP_MATCHING_PKG.base_credit_rcv_match<-'||X_calling_sequence;
302:
303: l_debug_info := 'Get Invoice and System Options information';
304: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1070: X_Match_Quantity IN NUMBER,
1071: X_Match_Amount IN NUMBER,
1072: X_Unit_Price IN NUMBER,
1073: X_Dist_Tab IN OUT NOCOPY
1074: AP_MATCHING_PKG.DIST_TAB_TYPE,
1075: X_Calling_Sequence IN VARCHAR2) IS
1076:
1077: --Modified below cursor for bug #7015553 to receive projec_id and task_id
1078: --values from receivables tables if these are different in PO and receipt.
1673: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1674: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1675: END IF;
1676: -- Bug 5465722
1677: ap_matching_pkg.build_prepay_account(
1678: P_base_ccid => x_dist_tab(i).po_ccid,
1679: P_overlay_ccid => g_prepay_ccid,
1680: P_accounting_date => g_line_accounting_date,
1681: P_result_Ccid => l_dist_ccid,
2689:
2690: PROCEDURE Insert_Invoice_Distributions (X_Invoice_ID IN NUMBER,
2691: X_Invoice_Line_Number IN NUMBER,
2692: X_Dist_Tab IN OUT NOCOPY
2693: AP_MATCHING_PKG.Dist_Tab_Type,
2694: X_Rcv_Transaction_Id IN NUMBER,
2695: X_Total_Amount IN NUMBER,
2696: X_Calling_Sequence IN VARCHAR2) IS
2697:
3145: END Insert_Invoice_Distributions;
3146:
3147:
3148: Procedure Update_PO_Shipments_Dists(
3149: X_Dist_Tab IN OUT NOCOPY AP_MATCHING_PKG.Dist_Tab_Type,
3150: X_Po_Line_Location_Id IN NUMBER,
3151: X_Match_Amount IN NUMBER,
3152: X_Match_Quantity IN NUMBER,
3153: X_Uom_Lookup_Code IN VARCHAR2,
3481: X_Match_Mode IN VARCHAR2,
3482: X_Po_Line_Location_Id IN NUMBER,
3483: X_Rcv_Transaction_Id IN NUMBER,
3484: x_CORR_dIST_tAB IN OUT NOCOPY
3485: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
3486: X_Uom_Lookup_Code IN VARCHAR2,
3487: X_Retained_Amount IN NUMBER DEFAULT NULL,
3488: X_Calling_Sequence IN VARCHAR2) IS
3489:
3740: PROCEDURE Get_Corr_Dist_Proration_Info(
3741: x_corrected_invoice_id IN NUMBER,
3742: x_corrected_line_number IN NUMBER,
3743: x_corr_dist_tab IN OUT NOCOPY
3744: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
3745: x_correction_type IN VARCHAR2,
3746: x_correction_amount IN NUMBER,
3747: x_correction_quantity IN NUMBER,
3748: x_correction_price IN NUMBER,
4053:
4054:
4055:
4056: PROCEDURE Update_Corr_Po_Shipments_Dists(
4057: X_Corr_Dist_Tab IN AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
4058: X_Po_Line_Location_Id IN NUMBER,
4059: X_Quantity IN NUMBER,
4060: X_Amount IN NUMBER,
4061: X_Correction_Type IN VARCHAR2,
4077:
4078: current_calling_sequence := 'Update_Corr_Po_Shipments_Dists<-'||x_calling_sequence;
4079:
4080: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4081: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Distributions(+)');
4082: END IF;
4083:
4084: l_debug_info := 'Create l_po_ap_dist_rec object';
4085: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4182: X_Msg_Data => l_msg_data);
4183:
4184:
4185: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4186: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_MATCHING_PKG.Update_Corr_Po_Shipments_Dists(-)');
4187: END IF;
4188:
4189:
4190: EXCEPTION
4577: PROCEDURE Insert_Corr_Invoice_Dists(x_invoice_id IN NUMBER,
4578: x_invoice_line_number IN NUMBER,
4579: x_corrected_invoice_id IN NUMBER,
4580: x_corr_dist_tab IN OUT NOCOPY
4581: AP_MATCHING_PKG.CORR_DIST_TAB_TYPE,
4582: x_correction_type IN VARCHAR2,
4583: x_total_amount IN NUMBER,
4584: x_calling_sequence IN VARCHAR2) IS
4585: