DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICES_ALL

Line 32: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;

28: l_inv_dist_list Inv_Dists_Tab_Type;
29: l_tax_dist_list Inv_Dists_Tab_Type;
30: p_rct_match_tax_list Inv_Lines_Tab_Type;
31:
32: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
33: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;
34: l_sysdate DATE := sysdate;
35: g_manual_tax_lines VARCHAR2(1) := 'N';
36: g_invoices_to_process NUMBER;

Line 33: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;

29: l_tax_dist_list Inv_Dists_Tab_Type;
30: p_rct_match_tax_list Inv_Lines_Tab_Type;
31:
32: l_user_id ap_invoices_all.created_by%TYPE := FND_GLOBAL.user_id;
33: l_login_id ap_invoices_all.last_update_login%TYPE := FND_GLOBAL.login_id;
34: l_sysdate DATE := sysdate;
35: g_manual_tax_lines VARCHAR2(1) := 'N';
36: g_invoices_to_process NUMBER;
37:

Line 40: l_inv_header_rec2 ap_invoices_all%rowtype; -- For bug 6064593

36: g_invoices_to_process NUMBER;
37:
38: l_payment_request_flag varchar2(1); ---for bug 5967914
39: l_manual_tax_line_rcv_mtch varchar2(1);
40: l_inv_header_rec2 ap_invoices_all%rowtype; -- For bug 6064593
41:
42: PROCEDURE Cache_Line_Defaults
43: (p_org_id IN ap_invoices_all.org_id%type,
44: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,

Line 43: (p_org_id IN ap_invoices_all.org_id%type,

39: l_manual_tax_line_rcv_mtch varchar2(1);
40: l_inv_header_rec2 ap_invoices_all%rowtype; -- For bug 6064593
41:
42: PROCEDURE Cache_Line_Defaults
43: (p_org_id IN ap_invoices_all.org_id%type,
44: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
45: p_calling_sequence IN VARCHAR2);
46:
47: FUNCTION CANCEL_INVOICE

Line 64: (P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

60: x_inv_price OUT NOCOPY NUMBER,
61: x_inv_qty OUT NOCOPY NUMBER);
62:
63: FUNCTION Populate_Rct_Match_Lines_GT
64: (P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
65: P_Event_Class_Code IN VARCHAR2,
66: P_Error_Code OUT NOCOPY VARCHAR2,
67: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
68:

Line 70: (P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,

66: P_Error_Code OUT NOCOPY VARCHAR2,
67: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
68:
69: FUNCTION Update_Distributions
70: (P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,
71: P_Calling_Mode IN VARCHAR2,
72: P_All_Error_Messages IN VARCHAR2,
73: P_Error_Code OUT NOCOPY VARCHAR2,
74: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;

Line 80: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

76: PROCEDURE Print(p_api_name IN VARCHAR2,
77: p_debug_info IN VARCHAR2);
78:
79: FUNCTION Return_Other_Charge_Lines(
80: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
81: P_Error_Code OUT NOCOPY VARCHAR2,
82: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN;
83:
84: -- Bug 6694536

Line 88: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

84: -- Bug 6694536
85: FUNCTION SELF_ASSESS_TAX_DIST_EXIST
86: (p_invoice_id IN NUMBER) RETURN BOOLEAN;
87: FUNCTION Freeze_Distributions(
88: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
89: P_Calling_Mode IN VARCHAR2,
90: P_Event_Class_Code IN VARCHAR2,
91: P_All_Error_Messages IN VARCHAR2,
92: P_Error_Code OUT NOCOPY VARCHAR2,

Line 180: l_inv_header_rec ap_invoices_all%ROWTYPE;

176:
177: l_debug_info VARCHAR2(240);
178: l_curr_calling_sequence VARCHAR2(4000);
179:
180: l_inv_header_rec ap_invoices_all%ROWTYPE;
181: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
182: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
183:
184: l_tax_already_calculated VARCHAR2(1);

Line 201: FROM ap_invoices_all

197: l_api_name CONSTANT VARCHAR2(100) := 'Calculate';
198:
199: CURSOR Invoice_Header (c_invoice_id NUMBER) IS
200: SELECT *
201: FROM ap_invoices_all
202: WHERE invoice_id = c_invoice_Id;
203:
204: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
205: SELECT *

Line 227: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;

223: WHERE invoice_id = c_invoice_id
224: AND line_type_lookup_code = 'TAX'
225: AND summary_tax_line_id IS NULL;
226:
227: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;
228:
229: CURSOR c_selected_invoices IS
230: SELECT trx_id, event_class_code
231: FROM zx_trx_headers_gt

Line 865: l_inv_header_rec ap_invoices_all%ROWTYPE;

861: l_msg_data VARCHAR2(4000);
862: l_msg VARCHAR2(4000);
863:
864: l_return_status BOOLEAN := TRUE;
865: l_inv_header_rec ap_invoices_all%ROWTYPE;
866:
867: CURSOR Invoice_Header IS
868: SELECT *
869: FROM ap_invoices_all

Line 869: FROM ap_invoices_all

865: l_inv_header_rec ap_invoices_all%ROWTYPE;
866:
867: CURSOR Invoice_Header IS
868: SELECT *
869: FROM ap_invoices_all
870: WHERE invoice_id = P_Invoice_Id;
871:
872: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
873: SELECT *

Line 1156: l_inv_header_rec ap_invoices_all%ROWTYPE;

1152: l_debug_info VARCHAR2(240);
1153: l_curr_calling_sequence VARCHAR2(4000);
1154: l_api_name CONSTANT VARCHAR2(100) := 'Distribute';
1155:
1156: l_inv_header_rec ap_invoices_all%ROWTYPE;
1157: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
1158: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
1159:
1160: l_return_status_service VARCHAR2(4000);

Line 1175: FROM ap_invoices_all

1171: call_determine_recovery_flag BOOLEAN := FALSE;
1172:
1173: CURSOR Invoice_Header (c_invoice_id NUMBER) IS
1174: SELECT *
1175: FROM ap_invoices_all
1176: WHERE invoice_id = c_invoice_id;
1177:
1178: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1179: SELECT aid.*

Line 1732: l_inv_header_rec ap_invoices_all%ROWTYPE;

1728: l_msg_data VARCHAR2(4000);
1729: l_msg VARCHAR2(4000);
1730: l_return_status BOOLEAN := TRUE;
1731:
1732: l_inv_header_rec ap_invoices_all%ROWTYPE;
1733: l_api_name varchar2(30) := 'Distribute_import'; -- bug 6321366
1734: CURSOR Invoice_Header IS
1735: SELECT *
1736: FROM ap_invoices_all

Line 1736: FROM ap_invoices_all

1732: l_inv_header_rec ap_invoices_all%ROWTYPE;
1733: l_api_name varchar2(30) := 'Distribute_import'; -- bug 6321366
1734: CURSOR Invoice_Header IS
1735: SELECT *
1736: FROM ap_invoices_all
1737: WHERE invoice_id = P_Invoice_Id;
1738:
1739: BEGIN
1740:

Line 1877: l_inv_header_rec ap_invoices_all%ROWTYPE;

1873: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
1874: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
1875:
1876: l_return_status BOOLEAN := TRUE;
1877: l_inv_header_rec ap_invoices_all%ROWTYPE;
1878:
1879: CURSOR Invoice_Header IS
1880: SELECT *
1881: FROM ap_invoices_all

Line 1881: FROM ap_invoices_all

1877: l_inv_header_rec ap_invoices_all%ROWTYPE;
1878:
1879: CURSOR Invoice_Header IS
1880: SELECT *
1881: FROM ap_invoices_all
1882: WHERE invoice_id = P_Invoice_Id;
1883:
1884: BEGIN
1885: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Import_Interface<-' ||

Line 2079: l_inv_header_rec ap_invoices_all%ROWTYPE;

2075:
2076: l_debug_info VARCHAR2(240);
2077: l_curr_calling_sequence VARCHAR2(4000);
2078:
2079: l_inv_header_rec ap_invoices_all%ROWTYPE;
2080: l_credited_inv_rec ap_invoices_all%ROWTYPE;
2081:
2082: l_event_class_code_crediting zx_trx_headers_gt.event_class_code%TYPE;
2083: l_event_class_code_credited zx_trx_headers_gt.event_class_code%TYPE;

Line 2080: l_credited_inv_rec ap_invoices_all%ROWTYPE;

2076: l_debug_info VARCHAR2(240);
2077: l_curr_calling_sequence VARCHAR2(4000);
2078:
2079: l_inv_header_rec ap_invoices_all%ROWTYPE;
2080: l_credited_inv_rec ap_invoices_all%ROWTYPE;
2081:
2082: l_event_class_code_crediting zx_trx_headers_gt.event_class_code%TYPE;
2083: l_event_class_code_credited zx_trx_headers_gt.event_class_code%TYPE;
2084:

Line 2091: FROM ap_invoices_all

2087: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2088:
2089: CURSOR Crediting_Inv_Header IS
2090: SELECT *
2091: FROM ap_invoices_all
2092: WHERE invoice_id = P_Invoice_Id
2093: AND quick_credit = 'Y'
2094: AND credited_invoice_id IS NOT NULL;
2095:

Line 2098: FROM ap_invoices_all

2094: AND credited_invoice_id IS NOT NULL;
2095:
2096: CURSOR Credited_Inv_Header(c_credited_inv NUMBER) IS
2097: SELECT *
2098: FROM ap_invoices_all
2099: WHERE invoice_id = c_credited_inv;
2100:
2101: l_return_status_service VARCHAR2(4000);
2102: l_msg_count NUMBER;

Line 2466: l_inv_header_rec ap_invoices_all%ROWTYPE;

2462:
2463: l_debug_info VARCHAR2(240);
2464: l_curr_calling_sequence VARCHAR2(4000);
2465:
2466: l_inv_header_rec ap_invoices_all%ROWTYPE;
2467: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
2468: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2469: l_transaction_rec zx_api_pub.transaction_rec_type;
2470:

Line 2473: FROM ap_invoices_all

2469: l_transaction_rec zx_api_pub.transaction_rec_type;
2470:
2471: CURSOR Invoice_Header IS
2472: SELECT *
2473: FROM ap_invoices_all
2474: WHERE invoice_id = P_Invoice_Id;
2475:
2476: CURSOR Invoice_Lines IS
2477: SELECT *

Line 2828: UPDATE ap_invoices_all ai

2824: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2825: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2826: END IF;
2827: -----------------------------------------------------------------
2828: UPDATE ap_invoices_all ai
2829: SET (ai.total_tax_amount,
2830: ai.self_assessed_tax_amount) =
2831: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2832: 'N', NVL(zls.tax_amt, 0),

Line 2904: l_inv_header_rec ap_invoices_all%ROWTYPE;

2900:
2901: l_debug_info VARCHAR2(240);
2902: l_curr_calling_sequence VARCHAR2(4000);
2903:
2904: l_inv_header_rec ap_invoices_all%ROWTYPE;
2905: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
2906: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2907:
2908: CURSOR Invoice_Header IS

Line 2910: FROM ap_invoices_all

2906: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2907:
2908: CURSOR Invoice_Header IS
2909: SELECT *
2910: FROM ap_invoices_all
2911: WHERE invoice_id = P_Invoice_Id;
2912:
2913: l_transaction_rec zx_api_pub.transaction_rec_type;
2914:

Line 3123: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

3119: |
3120: *============================================================================*/
3121:
3122: FUNCTION Freeze_itm_Distributions(
3123: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
3124: P_Calling_Mode IN VARCHAR2,
3125: P_Event_Class_Code IN VARCHAR2,
3126: P_All_Error_Messages IN VARCHAR2,
3127: P_Error_Code OUT NOCOPY VARCHAR2,

Line 3491: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

3487: |
3488: *============================================================================*/
3489:
3490: FUNCTION Freeze_Distributions(
3491: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
3492: P_Calling_Mode IN VARCHAR2,
3493: P_Event_Class_Code IN VARCHAR2,
3494: P_All_Error_Messages IN VARCHAR2,
3495: P_Error_Code OUT NOCOPY VARCHAR2,

Line 3937: l_inv_header_rec ap_invoices_all%ROWTYPE;

3933:
3934: l_debug_info VARCHAR2(240);
3935: l_curr_calling_sequence VARCHAR2(4000);
3936:
3937: l_inv_header_rec ap_invoices_all%ROWTYPE;
3938: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
3939: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3940:
3941: CURSOR Invoice_Header IS

Line 3943: FROM ap_invoices_all

3939: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3940:
3941: CURSOR Invoice_Header IS
3942: SELECT *
3943: FROM ap_invoices_all
3944: WHERE invoice_id = P_Invoice_Id;
3945:
3946: l_transaction_rec zx_api_pub.transaction_rec_type;
3947:

Line 3978: UPDATE ap_invoices_all ail

3974: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
3976: END IF;
3977:
3978: UPDATE ap_invoices_all ail
3979: SET control_amount= NULL --Bug6887264
3980: WHERE ail.invoice_id = p_invoice_id
3981: AND P_Calling_Mode = 'CANCEL INVOICE'
3982: AND ail.control_amount IS NOT NULL ;

Line 4290: l_inv_header_rec ap_invoices_all%ROWTYPE;

4286:
4287: l_debug_info VARCHAR2(240);
4288: l_curr_calling_sequence VARCHAR2(4000);
4289:
4290: l_inv_header_rec ap_invoices_all%ROWTYPE;
4291: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
4292: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4293:
4294: CURSOR Invoice_Header IS

Line 4296: FROM ap_invoices_all

4292: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4293:
4294: CURSOR Invoice_Header IS
4295: SELECT *
4296: FROM ap_invoices_all
4297: WHERE invoice_id = P_Invoice_Id;
4298:
4299: l_transaction_rec zx_api_pub.transaction_rec_type;
4300: l_validation_status zx_api_pub.validation_status_tbl_type;

Line 4488: l_inv_header_rec ap_invoices_all%ROWTYPE;

4484:
4485: l_debug_info VARCHAR2(240);
4486: l_curr_calling_sequence VARCHAR2(4000);
4487:
4488: l_inv_header_rec ap_invoices_all%ROWTYPE;
4489: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
4490: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4491:
4492: CURSOR Invoice_Header IS

Line 4494: FROM ap_invoices_all

4490: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4491:
4492: CURSOR Invoice_Header IS
4493: SELECT *
4494: FROM ap_invoices_all
4495: WHERE invoice_id = P_Invoice_Id;
4496:
4497: l_transaction_line_rec zx_api_pub.transaction_line_rec_type;
4498:

Line 4655: l_inv_header_rec ap_invoices_all%ROWTYPE;

4651:
4652: l_debug_info VARCHAR2(240);
4653: l_curr_calling_sequence VARCHAR2(4000);
4654:
4655: l_inv_header_rec ap_invoices_all%ROWTYPE;
4656: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
4657: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4658:
4659: CURSOR Invoice_Header IS

Line 4661: FROM ap_invoices_all

4657: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4658:
4659: CURSOR Invoice_Header IS
4660: SELECT *
4661: FROM ap_invoices_all
4662: WHERE invoice_id = P_Invoice_Id;
4663:
4664: l_transaction_rec zx_api_pub.transaction_rec_type;
4665:

Line 5112: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

5108: |
5109: *============================================================================*/
5110:
5111: FUNCTION Populate_Headers_GT(
5112: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
5113: P_Calling_Mode IN VARCHAR2,
5114: P_eTax_Already_called_flag IN VARCHAR2,
5115: P_Event_Class_Code OUT NOCOPY VARCHAR2,
5116: P_Event_Type_Code OUT NOCOPY VARCHAR2,

Line 5134: FROM ap_invoices_all

5130:
5131: CURSOR tax_related_invoice( c_tax_related_invoice_id IN NUMBER) IS
5132: -- B# 6907814 ... SELECT invoice_num, invoice_date, invoice_type_lookup_code
5133: SELECT invoice_num, invoice_type_lookup_code, invoice_date
5134: FROM ap_invoices_all
5135: WHERE invoice_id = c_tax_related_invoice_id;
5136:
5137: l_related_inv_application_id
5138: zx_trx_headers_gt.related_doc_application_id%TYPE;

Line 5143: l_related_inv_number ap_invoices_all.invoice_num%TYPE;

5139: l_related_inv_entity_code
5140: zx_trx_headers_gt.related_doc_entity_code%TYPE;
5141: l_related_event_class_code
5142: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5143: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5144: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5145: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5146:
5147: l_precision fnd_currencies.precision%TYPE;

Line 5144: l_related_inv_date ap_invoices_all.invoice_date%TYPE;

5140: zx_trx_headers_gt.related_doc_entity_code%TYPE;
5141: l_related_event_class_code
5142: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5143: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5144: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5145: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5146:
5147: l_precision fnd_currencies.precision%TYPE;
5148: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 5145: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

5141: l_related_event_class_code
5142: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5143: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5144: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5145: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5146:
5147: l_precision fnd_currencies.precision%TYPE;
5148: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
5149: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;

Line 5530: FROM ap_invoices_all

5526:
5527: CURSOR tax_related_invoice( c_tax_related_invoice_id IN NUMBER) IS
5528: -- B# 6907814 ... SELECT invoice_num, invoice_date, invoice_type_lookup_code
5529: SELECT invoice_num, invoice_type_lookup_code, invoice_date
5530: FROM ap_invoices_all
5531: WHERE invoice_id = c_tax_related_invoice_id;
5532:
5533: l_related_inv_application_id
5534: zx_trx_headers_gt.related_doc_application_id%TYPE;

Line 5539: l_related_inv_number ap_invoices_all.invoice_num%TYPE;

5535: l_related_inv_entity_code
5536: zx_trx_headers_gt.related_doc_entity_code%TYPE;
5537: l_related_event_class_code
5538: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5539: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5542:
5543: l_precision fnd_currencies.precision%TYPE := 0;

Line 5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;

5536: zx_trx_headers_gt.related_doc_entity_code%TYPE;
5537: l_related_event_class_code
5538: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5539: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5542:
5543: l_precision fnd_currencies.precision%TYPE := 0;
5544: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

5537: l_related_event_class_code
5538: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
5539: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
5540: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
5541: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
5542:
5543: l_precision fnd_currencies.precision%TYPE := 0;
5544: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
5545:

Line 5879: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

5875: |
5876: *============================================================================*/
5877:
5878: FUNCTION Populate_Lines_GT(
5879: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
5880: P_Calling_Mode IN VARCHAR2,
5881: P_Event_Class_Code IN VARCHAR2,
5882: P_Line_Number IN NUMBER DEFAULT NULL,
5883: P_Error_Code OUT NOCOPY VARCHAR2,

Line 5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;

5924: -- Prepayment Info
5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;

Line 5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

5925: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
5926: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
5927: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
5928: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
5929: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
5930: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
5931: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
5932: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
5933:

Line 6403: ap_invoices_all ai

6399: SELECT aerd.code_combination_id
6400: INTO l_inv_line_list(i).default_dist_ccid
6401: FROM ap_exp_report_dists_all aerd,
6402: ap_expense_report_lines_all aerl,
6403: ap_invoices_all ai
6404: WHERE aerd.report_header_id = l_inv_line_list(i).reference_key1
6405: AND aerd.report_line_id = l_inv_line_list(i).reference_key2
6406: AND aerd.report_line_id = aerl.report_line_id
6407: AND aerd.report_header_id = aerl.report_header_id

Line 7891: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

7887: | 06-FEB-2004 SYIDNER Created
7888: |
7889: *============================================================================*/
7890: FUNCTION Populate_Tax_Lines_GT(
7891: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
7892: P_Calling_Mode IN VARCHAR2,
7893: P_Event_Class_Code IN VARCHAR2,
7894: P_Tax_only_Flag IN VARCHAR2,
7895: P_Inv_Rcv_Matched IN OUT NOCOPY VARCHAR2,

Line 8627: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

8623: |
8624: *============================================================================*/
8625:
8626: FUNCTION Populate_Distributions_GT(
8627: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
8628: P_Calling_Mode IN VARCHAR2,
8629: P_Event_Class_Code IN VARCHAR2,
8630: P_Event_Type_Code IN VARCHAR2,
8631: P_Error_Code OUT NOCOPY VARCHAR2,

Line 8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;

8673: -- Prepayment Info
8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

Line 8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

8674: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
8675: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
8676: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
8677: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
8678: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
8679: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
8680: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
8681: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
8682:

Line 9106: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,

9102: |
9103: *============================================================================*/
9104:
9105: FUNCTION Update_AP(
9106: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,
9107: P_Calling_Mode IN VARCHAR2,
9108: P_All_Error_Messages IN VARCHAR2,
9109: P_Error_Code OUT NOCOPY VARCHAR2,
9110: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN

Line 9243: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

9239: | 13-AUG-2004 Sanjay Created
9240: *============================================================================*/
9241:
9242: FUNCTION CALCULATE_QUOTE(
9243: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
9244: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,
9245: P_Calling_Mode IN VARCHAR2,
9246: P_Tax_Amount OUT NOCOPY NUMBER,
9247: P_Tax_Amt_Included OUT NOCOPY VARCHAR2,

Line 12191: UPDATE ap_invoices_all ai

12187: and zx.trx_line_id = p_line_number);
12188:
12189: END IF;
12190:
12191: UPDATE ap_invoices_all ai
12192: SET (ai.total_tax_amount,
12193: ai.self_assessed_tax_amount) =
12194: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
12195: 'N', NVL(zls.tax_amt, 0),

Line 12337: FROM ap_invoices_all

12333: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
12334:
12335: CURSOR invoice_header IS
12336: SELECT *
12337: FROM ap_invoices_all
12338: WHERE invoice_id = P_Invoice_Id;
12339:
12340: CURSOR prepay_lines IS
12341: SELECT distinct prepLine.*

Line 12352: l_inv_header_rec ap_invoices_all%ROWTYPE;

12348: AND invDist.line_type_lookup_code = 'PREPAY'
12349: AND invDist.invoice_id = p_invoice_id
12350: AND invDist.invoice_line_number = p_invoice_line_number;
12351:
12352: l_inv_header_rec ap_invoices_all%ROWTYPE;
12353: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
12354: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
12355:
12356: l_tax_already_calculated VARCHAR2(1);

Line 12592: l_invoice_header_rec ap_invoices_all%rowtype;

12588: ('NONREC_TAX', 'REC_TAX', 'TRV', 'TERV', 'TIPV', 'AWT')
12589: And (related_id IS NULL
12590: or related_id = invoice_distribution_id);
12591:
12592: l_invoice_header_rec ap_invoices_all%rowtype;
12593: l_application_id zx_trx_headers_gt.application_id%TYPE;
12594: l_entity_code zx_trx_headers_gt.entity_code%TYPE;
12595: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
12596: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;

Line 12634: From ap_invoices_all

12630: -------------------------------------------------------------------
12631: l_debug_info := 'Step 1: Get invoice header details';
12632: -------------------------------------------------------------------
12633: Select * Into l_invoice_header_rec
12634: From ap_invoices_all
12635: Where invoice_id = p_invoice_id;
12636:
12637: IF ((l_invoice_header_rec.quick_credit = 'Y') OR -- Bug 5660314
12638: (l_invoice_header_rec.invoice_type_lookup_code IN ('AWT', 'INTEREST'))) THEN

Line 12934: l_inv_header_rec ap_invoices_all%ROWTYPE;

12930:
12931: l_debug_info VARCHAR2(240);
12932: l_curr_calling_sequence VARCHAR2(4000);
12933:
12934: l_inv_header_rec ap_invoices_all%ROWTYPE;
12935: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
12936: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
12937:
12938: l_tax_already_calculated VARCHAR2(1);

Line 12951: FROM ap_invoices_all

12947: l_inv_rcv_matched VARCHAR2(1) := 'N';
12948:
12949: CURSOR Invoice_Header IS
12950: SELECT *
12951: FROM ap_invoices_all
12952: WHERE invoice_id = P_Invoice_Id;
12953:
12954: CURSOR Tax_Lines_to_import IS
12955: SELECT *

Line 13137: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

13133:
13134: END Calculate_Tax_Receipt_Match;
13135:
13136: FUNCTION Populate_Rct_Match_Lines_GT(
13137: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
13138: P_Event_Class_Code IN VARCHAR2,
13139: P_Error_Code OUT NOCOPY VARCHAR2,
13140: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
13141:

Line 13688: FROM ap_invoices_all ai,

13684: ai.vendor_id, --bill_third_pty_acct_id
13685: ai.vendor_site_id, --bill_third_pty_acct_site_id
13686: ai.vendor_id, --ship_third_pty_acct_id
13687: ai.vendor_site_id --ship_third_pty_acct_site_id
13688: FROM ap_invoices_all ai,
13689: fnd_currencies cur,
13690: fnd_document_sequences doc,
13691: ap_invoices_all related_ai
13692: WHERE ai.invoice_currency_code = cur.currency_code

Line 13691: ap_invoices_all related_ai

13687: ai.vendor_site_id --ship_third_pty_acct_site_id
13688: FROM ap_invoices_all ai,
13689: fnd_currencies cur,
13690: fnd_document_sequences doc,
13691: ap_invoices_all related_ai
13692: WHERE ai.invoice_currency_code = cur.currency_code
13693: AND ai.doc_sequence_id = doc.doc_sequence_id (+)
13694: AND ai.tax_related_invoice_id = related_ai.invoice_id (+)
13695: AND (nvl(ai.quick_credit,'N') = 'N'

Line 13718: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,

13714:
13715: END Bulk_Populate_Headers_GT;
13716:
13717: FUNCTION Update_Distributions(
13718: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,
13719: P_Calling_Mode IN VARCHAR2,
13720: P_All_Error_Messages IN VARCHAR2,
13721: P_Error_Code OUT NOCOPY VARCHAR2,
13722: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN

Line 14120: (p_org_id IN ap_invoices_all.org_id%type,

14116:
14117: END Update_Distributions;
14118:
14119: PROCEDURE Cache_Line_Defaults
14120: (p_org_id IN ap_invoices_all.org_id%type,
14121: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
14122: p_calling_sequence IN VARCHAR2) IS
14123:
14124: l_api_name VARCHAR2(30) := 'Cache_Line_Defaults';

Line 14183: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

14179: APP_EXCEPTION.RAISE_EXCEPTION;
14180: END Cache_Line_Defaults;
14181:
14182: FUNCTION Return_Other_Charge_Lines(
14183: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
14184: P_Error_Code OUT NOCOPY VARCHAR2,
14185: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
14186: IS
14187:

Line 14201: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

14197: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
14198: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
14199: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
14200: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
14201: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
14202: l_payment_priority ap_batches_all.payment_priority%TYPE;
14203:
14204: l_total_tax_amount NUMBER;
14205: l_self_assessed_tax_amt NUMBER;

Line 14724: FROM ap_invoices_all ai,

14720: zls.tax_rate_id, -- tax_rate_id
14721: zls.tax_rate_code, -- tax_rate_code
14722: zls.tax_rate, -- tax_rate
14723: null -- tax_code_id
14724: FROM ap_invoices_all ai,
14725: ap_suppliers ap,
14726: ap_supplier_sites_all aps,
14727: zx_lines_summary zls,
14728: ap_invoice_lines_all prepay

Line 14809: UPDATE ap_invoices_all ai

14805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14806: END IF;
14807: -------------------------------------------------------------------
14808: BEGIN
14809: UPDATE ap_invoices_all ai
14810: SET (ai.total_tax_amount,
14811: ai.self_assessed_tax_amount) =
14812: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14813: 'N', NVL(zls.tax_amt, 0),