eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 254: l_inv_header_rec ap_invoices_all%ROWTYPE;

250:
251: l_debug_info VARCHAR2(240);
252: l_curr_calling_sequence VARCHAR2(4000);
253:
254: l_inv_header_rec ap_invoices_all%ROWTYPE;
255: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
256: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
257:
258: l_tax_already_calculated VARCHAR2(1);

Line 276: FROM ap_invoices_all

272:
273:
274: CURSOR Invoice_Header (c_invoice_id NUMBER) IS
275: SELECT *
276: FROM ap_invoices_all
277: WHERE invoice_id = c_invoice_Id;
278:
279: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
280: SELECT *

Line 310: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;

306: AND summary_tax_line_id IS NULL
307: AND nvl(discarded_flag, 'N') <> 'Y' --Bug8811102
308: AND nvl(cancelled_flag, 'N') <> 'Y'; --Bug8811102
309:
310: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;
311:
312: CURSOR c_selected_invoices IS
313: SELECT trx_id, event_class_code
314: FROM zx_trx_headers_gt

Line 1171: l_inv_header_rec ap_invoices_all%ROWTYPE;

1167: l_msg_data VARCHAR2(4000);
1168: l_msg VARCHAR2(4000);
1169:
1170: l_return_status BOOLEAN := TRUE;
1171: l_inv_header_rec ap_invoices_all%ROWTYPE;
1172:
1173: CURSOR Invoice_Header IS
1174: SELECT *
1175: FROM ap_invoices_all

Line 1175: FROM ap_invoices_all

1171: l_inv_header_rec ap_invoices_all%ROWTYPE;
1172:
1173: CURSOR Invoice_Header IS
1174: SELECT *
1175: FROM ap_invoices_all
1176: WHERE invoice_id = P_Invoice_Id;
1177:
1178: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS
1179: SELECT *

Line 1518: l_inv_header_rec ap_invoices_all%ROWTYPE;

1514: l_debug_info VARCHAR2(240);
1515: l_curr_calling_sequence VARCHAR2(4000);
1516: l_api_name CONSTANT VARCHAR2(100) := 'Distribute';
1517:
1518: l_inv_header_rec ap_invoices_all%ROWTYPE;
1519: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
1520: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
1521:
1522: l_return_status_service VARCHAR2(4000);

Line 1537: FROM ap_invoices_all ai,

1533: call_determine_recovery_flag BOOLEAN := FALSE;
1534:
1535: CURSOR Invoice_Header (c_invoice_id NUMBER) IS
1536: SELECT ai.*
1537: FROM ap_invoices_all ai,
1538: ap_system_parameters_all asp --Bug14779241
1539: WHERE ai.invoice_id = c_invoice_id
1540: AND asp.org_id = ai.org_id /* Bug14779241: Start */
1541: AND ((asp.base_currency_code = ai.invoice_currency_code) OR

Line 1549: ap_invoices_all ai , --Bug14779241

1545: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1546: SELECT aid.*
1547: FROM ap_invoice_lines_all ail,
1548: ap_invoice_distributions_all aid,
1549: ap_invoices_all ai , --Bug14779241
1550: ap_system_parameters_all asp --Bug14779241
1551: WHERE ail.invoice_id = aid.invoice_id
1552: AND ail.line_number = aid.invoice_line_number
1553: AND ail.invoice_id = c_invoice_id

Line 1583: ap_invoices_all ai, --Bug14779241

1579: UNION
1580: SELECT aid.*
1581: FROM ap_invoice_lines_all ail,
1582: ap_invoice_distributions_all aid,
1583: ap_invoices_all ai, --Bug14779241
1584: ap_system_parameters_all asp --Bug14779241
1585: WHERE ail.invoice_id = aid.invoice_id
1586: AND ail.line_number = aid.invoice_line_number
1587: AND ail.invoice_id = c_invoice_id

Line 1611: ap_invoices_all ai, --Bug14779241

1607: CURSOR Invoice_Dist (c_invoice_id NUMBER, c_line_number NUMBER) IS
1608: SELECT aid.*
1609: FROM ap_invoice_lines_all ail,
1610: ap_invoice_distributions_all aid,
1611: ap_invoices_all ai, --Bug14779241
1612: ap_system_parameters_all asp --Bug14779241
1613: WHERE ail.invoice_id = aid.invoice_id
1614: AND ail.line_number = aid.invoice_line_number
1615: AND ail.invoice_id = c_invoice_id

Line 1643: ap_invoices_all ai, --Bug14779241

1639: UNION
1640: SELECT aid.*
1641: FROM ap_invoice_lines_all ail,
1642: ap_invoice_distributions_all aid,
1643: ap_invoices_all ai, --Bug14779241
1644: ap_system_parameters_all asp --Bug14779241
1645: WHERE ail.invoice_id = aid.invoice_id
1646: AND ail.line_number = aid.invoice_line_number
1647: AND ail.invoice_id = c_invoice_id

Line 1702: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;

1698: --ER CHANGES 6772098
1699:
1700: --Bug9436217
1701:
1702: l_validation_request_id ap_invoices_all.validation_request_id%TYPE;
1703:
1704: --Bug9436217
1705:
1706: BEGIN

Line 2229: l_inv_header_rec ap_invoices_all%ROWTYPE;

2225: l_msg_data VARCHAR2(4000);
2226: l_msg VARCHAR2(4000);
2227: l_return_status BOOLEAN := TRUE;
2228:
2229: l_inv_header_rec ap_invoices_all%ROWTYPE;
2230: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241
2231: l_api_name varchar2(30) := 'Distribute_import'; -- bug 6321366
2232: CURSOR Invoice_Header IS
2233: SELECT *

Line 2230: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241

2226: l_msg VARCHAR2(4000);
2227: l_return_status BOOLEAN := TRUE;
2228:
2229: l_inv_header_rec ap_invoices_all%ROWTYPE;
2230: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241
2231: l_api_name varchar2(30) := 'Distribute_import'; -- bug 6321366
2232: CURSOR Invoice_Header IS
2233: SELECT *
2234: FROM ap_invoices_all

Line 2234: FROM ap_invoices_all

2230: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241
2231: l_api_name varchar2(30) := 'Distribute_import'; -- bug 6321366
2232: CURSOR Invoice_Header IS
2233: SELECT *
2234: FROM ap_invoices_all
2235: WHERE invoice_id = P_Invoice_Id;
2236:
2237: CURSOR Invoice_ex_rate_check IS --Bug14779241
2238: SELECT ai.invoice_id

Line 2239: FROM ap_invoices_all ai,

2235: WHERE invoice_id = P_Invoice_Id;
2236:
2237: CURSOR Invoice_ex_rate_check IS --Bug14779241
2238: SELECT ai.invoice_id
2239: FROM ap_invoices_all ai,
2240: ap_system_parameters_all asp
2241: WHERE ai.invoice_id = P_Invoice_Id
2242: AND asp.org_id = ai.org_id
2243: AND ((asp.base_currency_code = ai.invoice_currency_code) OR

Line 2414: l_inv_header_rec ap_invoices_all%ROWTYPE;

2410: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
2411: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2412:
2413: l_return_status BOOLEAN := TRUE;
2414: l_inv_header_rec ap_invoices_all%ROWTYPE;
2415: l_api_name varchar2(30) := 'Import_Interface';
2416: l_inv_rcv_matched VARCHAR2(1) := 'N'; --BUG 16656238
2417:
2418: CURSOR Invoice_Header IS

Line 2420: FROM ap_invoices_all

2416: l_inv_rcv_matched VARCHAR2(1) := 'N'; --BUG 16656238
2417:
2418: CURSOR Invoice_Header IS
2419: SELECT *
2420: FROM ap_invoices_all
2421: WHERE invoice_id = P_Invoice_Id;
2422:
2423: --BUG 16656238
2424: CURSOR Invoice_Lines (c_invoice_id NUMBER) IS

Line 2761: l_inv_header_rec ap_invoices_all%ROWTYPE;

2757:
2758: l_debug_info VARCHAR2(240);
2759: l_curr_calling_sequence VARCHAR2(4000);
2760:
2761: l_inv_header_rec ap_invoices_all%ROWTYPE;
2762: l_credited_inv_rec ap_invoices_all%ROWTYPE;
2763:
2764: l_event_class_code_crediting zx_trx_headers_gt.event_class_code%TYPE;
2765: l_event_class_code_credited zx_trx_headers_gt.event_class_code%TYPE;

Line 2762: l_credited_inv_rec ap_invoices_all%ROWTYPE;

2758: l_debug_info VARCHAR2(240);
2759: l_curr_calling_sequence VARCHAR2(4000);
2760:
2761: l_inv_header_rec ap_invoices_all%ROWTYPE;
2762: l_credited_inv_rec ap_invoices_all%ROWTYPE;
2763:
2764: l_event_class_code_crediting zx_trx_headers_gt.event_class_code%TYPE;
2765: l_event_class_code_credited zx_trx_headers_gt.event_class_code%TYPE;
2766:

Line 2773: FROM ap_invoices_all

2769: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
2770:
2771: CURSOR Crediting_Inv_Header IS
2772: SELECT *
2773: FROM ap_invoices_all
2774: WHERE invoice_id = P_Invoice_Id
2775: AND quick_credit = 'Y'
2776: AND credited_invoice_id IS NOT NULL;
2777:

Line 2780: FROM ap_invoices_all

2776: AND credited_invoice_id IS NOT NULL;
2777:
2778: CURSOR Credited_Inv_Header(c_credited_inv NUMBER) IS
2779: SELECT *
2780: FROM ap_invoices_all
2781: WHERE invoice_id = c_credited_inv;
2782:
2783: l_return_status_service VARCHAR2(4000);
2784: l_msg_count NUMBER;

Line 3156: l_inv_header_rec ap_invoices_all%ROWTYPE;

3152:
3153: l_debug_info VARCHAR2(240);
3154: l_curr_calling_sequence VARCHAR2(4000);
3155:
3156: l_inv_header_rec ap_invoices_all%ROWTYPE;
3157: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241
3158: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
3159: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3160: l_transaction_rec zx_api_pub.transaction_rec_type;

Line 3157: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241

3153: l_debug_info VARCHAR2(240);
3154: l_curr_calling_sequence VARCHAR2(4000);
3155:
3156: l_inv_header_rec ap_invoices_all%ROWTYPE;
3157: l_invoice_id ap_invoices_all.invoice_id%TYPE; --Bug14779241
3158: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
3159: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3160: l_transaction_rec zx_api_pub.transaction_rec_type;
3161:

Line 3164: FROM ap_invoices_all

3160: l_transaction_rec zx_api_pub.transaction_rec_type;
3161:
3162: CURSOR Invoice_Header IS
3163: SELECT *
3164: FROM ap_invoices_all
3165: WHERE invoice_id = P_Invoice_Id;
3166:
3167: CURSOR Invoice_Lines IS
3168: SELECT *

Line 3175: FROM ap_invoices_all ai,

3171: AND line_type_lookup_code NOT IN ('TAX', 'AWT');
3172:
3173: CURSOR Invoice_ex_rate_check IS --Bug14779241
3174: SELECT ai.invoice_id
3175: FROM ap_invoices_all ai,
3176: ap_system_parameters_all asp
3177: WHERE ai.invoice_id = P_Invoice_Id
3178: AND asp.org_id = ai.org_id
3179: AND ((asp.base_currency_code = ai.invoice_currency_code) OR

Line 3556: UPDATE ap_invoices_all ai

3552: IF ( l_return_status = TRUE ) THEN -- Bug 9383712
3553:
3554: --Modified below query for bug#16022947 to consider
3555: --Prepay lines
3556: UPDATE ap_invoices_all ai
3557: SET (ai.total_tax_amount,
3558: ai.self_assessed_tax_amount) =
3559: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
3560: 'N', case when exists (SELECT 'Prepay App Exists'

Line 3587: UPDATE ap_invoices_all ai

3583:
3584: --Bug#16022947. Introduced below UPDATE to consider
3585: --Retro Tax amounts which will not be in ZLS tables.
3586:
3587: UPDATE ap_invoices_all ai
3588: SET ai.total_tax_amount = (nvl(ai.total_tax_amount,0) +
3589: (SELECT NVL(sum(NVL(ail.amount,0)),0)
3590: FROM ap_invoice_lines_all ail
3591: WHERE ail.invoice_id = ai.invoice_id

Line 3674: l_inv_header_rec ap_invoices_all%ROWTYPE;

3670:
3671: l_debug_info VARCHAR2(240);
3672: l_curr_calling_sequence VARCHAR2(4000);
3673:
3674: l_inv_header_rec ap_invoices_all%ROWTYPE;
3675: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
3676: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3677:
3678: CURSOR Invoice_Header IS

Line 3680: FROM ap_invoices_all

3676: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
3677:
3678: CURSOR Invoice_Header IS
3679: SELECT *
3680: FROM ap_invoices_all
3681: WHERE invoice_id = P_Invoice_Id;
3682:
3683: l_transaction_rec zx_api_pub.transaction_rec_type;
3684:

Line 3911: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

3907: |
3908: *============================================================================*/
3909:
3910: FUNCTION Freeze_itm_Distributions(
3911: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
3912: P_Calling_Mode IN VARCHAR2,
3913: P_Event_Class_Code IN VARCHAR2,
3914: P_All_Error_Messages IN VARCHAR2,
3915: P_Error_Code OUT NOCOPY VARCHAR2,

Line 4338: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

4334: |
4335: *============================================================================*/
4336:
4337: FUNCTION Freeze_Distributions(
4338: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
4339: P_Calling_Mode IN VARCHAR2,
4340: P_Event_Class_Code IN VARCHAR2,
4341: P_All_Error_Messages IN VARCHAR2,
4342: P_Error_Code OUT NOCOPY VARCHAR2,

Line 4843: l_inv_header_rec ap_invoices_all%ROWTYPE;

4839:
4840: l_debug_info VARCHAR2(240);
4841: l_curr_calling_sequence VARCHAR2(4000);
4842:
4843: l_inv_header_rec ap_invoices_all%ROWTYPE;
4844: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
4845: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4846:
4847: CURSOR Invoice_Header IS

Line 4849: FROM ap_invoices_all

4845: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4846:
4847: CURSOR Invoice_Header IS
4848: SELECT *
4849: FROM ap_invoices_all
4850: WHERE invoice_id = P_Invoice_Id;
4851:
4852: l_transaction_rec zx_api_pub.transaction_rec_type;
4853:

Line 4884: UPDATE ap_invoices_all ail

4880: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4881: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
4882: END IF;
4883:
4884: UPDATE ap_invoices_all ail
4885: SET control_amount= NULL --Bug6887264
4886: WHERE ail.invoice_id = p_invoice_id
4887: AND P_Calling_Mode = 'CANCEL INVOICE'
4888: AND ail.control_amount IS NOT NULL ;

Line 4969: l_inv_header_rec ap_invoices_all%ROWTYPE;

4965:
4966: l_debug_info VARCHAR2(240);
4967: l_curr_calling_sequence VARCHAR2(4000);
4968:
4969: l_inv_header_rec ap_invoices_all%ROWTYPE;
4970: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
4971: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4972:
4973: CURSOR Invoice_Header IS

Line 4975: FROM ap_invoices_all

4971: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
4972:
4973: CURSOR Invoice_Header IS
4974: SELECT *
4975: FROM ap_invoices_all
4976: WHERE invoice_id = P_Invoice_Id;
4977:
4978: l_transaction_rec zx_api_pub.transaction_rec_type;
4979: l_validation_status zx_api_pub.validation_status_tbl_type;

Line 5197: l_inv_header_rec ap_invoices_all%ROWTYPE;

5193: l_debug_info VARCHAR2(240);
5194: l_curr_calling_sequence VARCHAR2(4000);
5195: --Bug8604959: Added debug logging
5196: l_api_name VARCHAR2(30) := 'Mark_Tax_Lines_Deleted';
5197: l_inv_header_rec ap_invoices_all%ROWTYPE;
5198: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
5199: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
5200:
5201: CURSOR Invoice_Header IS

Line 5203: FROM ap_invoices_all

5199: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
5200:
5201: CURSOR Invoice_Header IS
5202: SELECT *
5203: FROM ap_invoices_all
5204: WHERE invoice_id = P_Invoice_Id;
5205:
5206: l_transaction_line_rec zx_api_pub.transaction_line_rec_type;
5207:

Line 5472: l_inv_header_rec ap_invoices_all%ROWTYPE;

5468:
5469: l_debug_info VARCHAR2(240);
5470: l_curr_calling_sequence VARCHAR2(4000);
5471:
5472: l_inv_header_rec ap_invoices_all%ROWTYPE;
5473: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
5474: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
5475:
5476: CURSOR Invoice_Header IS

Line 5478: FROM ap_invoices_all

5474: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
5475:
5476: CURSOR Invoice_Header IS
5477: SELECT *
5478: FROM ap_invoices_all
5479: WHERE invoice_id = P_Invoice_Id;
5480:
5481: l_transaction_rec zx_api_pub.transaction_rec_type;
5482:

Line 6063: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

6059: |
6060: *============================================================================*/
6061:
6062: FUNCTION Populate_Headers_GT(
6063: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
6064: P_Calling_Mode IN VARCHAR2,
6065: P_eTax_Already_called_flag IN VARCHAR2,
6066: P_Event_Class_Code OUT NOCOPY VARCHAR2,
6067: P_Event_Type_Code OUT NOCOPY VARCHAR2,

Line 6085: FROM ap_invoices_all

6081:
6082: CURSOR tax_related_invoice( c_tax_related_invoice_id IN NUMBER) IS
6083: -- B# 6907814 ... SELECT invoice_num, invoice_date, invoice_type_lookup_code
6084: SELECT invoice_num, invoice_type_lookup_code, invoice_date
6085: FROM ap_invoices_all
6086: WHERE invoice_id = c_tax_related_invoice_id;
6087:
6088: l_related_inv_application_id
6089: zx_trx_headers_gt.related_doc_application_id%TYPE;

Line 6094: l_related_inv_number ap_invoices_all.invoice_num%TYPE;

6090: l_related_inv_entity_code
6091: zx_trx_headers_gt.related_doc_entity_code%TYPE;
6092: l_related_event_class_code
6093: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6094: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6095: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6096: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6097:
6098: l_precision fnd_currencies.precision%TYPE;

Line 6095: l_related_inv_date ap_invoices_all.invoice_date%TYPE;

6091: zx_trx_headers_gt.related_doc_entity_code%TYPE;
6092: l_related_event_class_code
6093: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6094: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6095: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6096: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6097:
6098: l_precision fnd_currencies.precision%TYPE;
6099: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 6096: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

6092: l_related_event_class_code
6093: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6094: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6095: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6096: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6097:
6098: l_precision fnd_currencies.precision%TYPE;
6099: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
6100: l_doc_seq_name fnd_document_sequences.db_sequence_name%TYPE;

Line 6514: FROM ap_invoices_all

6510:
6511: CURSOR tax_related_invoice( c_tax_related_invoice_id IN NUMBER) IS
6512: -- B# 6907814 ... SELECT invoice_num, invoice_date, invoice_type_lookup_code
6513: SELECT invoice_num, invoice_type_lookup_code, invoice_date
6514: FROM ap_invoices_all
6515: WHERE invoice_id = c_tax_related_invoice_id;
6516:
6517: l_related_inv_application_id
6518: zx_trx_headers_gt.related_doc_application_id%TYPE;

Line 6523: l_related_inv_number ap_invoices_all.invoice_num%TYPE;

6519: l_related_inv_entity_code
6520: zx_trx_headers_gt.related_doc_entity_code%TYPE;
6521: l_related_event_class_code
6522: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6523: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6526:
6527: l_precision fnd_currencies.precision%TYPE := 0;

Line 6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;

6520: zx_trx_headers_gt.related_doc_entity_code%TYPE;
6521: l_related_event_class_code
6522: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6523: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6526:
6527: l_precision fnd_currencies.precision%TYPE := 0;
6528: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;

Line 6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;

6521: l_related_event_class_code
6522: zx_trx_headers_gt.related_doc_event_class_code%TYPE;
6523: l_related_inv_number ap_invoices_all.invoice_num%TYPE;
6524: l_related_inv_date ap_invoices_all.invoice_date%TYPE;
6525: l_related_inv_type ap_invoices_all.invoice_type_lookup_code%TYPE;
6526:
6527: l_precision fnd_currencies.precision%TYPE := 0;
6528: l_minimum_accountable_unit fnd_currencies.minimum_accountable_unit%TYPE;
6529:

Line 6891: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

6887: |
6888: *============================================================================*/
6889:
6890: FUNCTION Populate_Lines_GT(
6891: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
6892: P_Calling_Mode IN VARCHAR2,
6893: P_Event_Class_Code IN VARCHAR2,
6894: P_Line_Number IN NUMBER DEFAULT NULL,
6895: P_Error_Code OUT NOCOPY VARCHAR2,

Line 6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;

6936: -- Prepayment Info
6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;

Line 6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

6937: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
6938: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
6939: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
6940: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
6941: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
6942: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
6943: l_applied_from_trx_id zx_transaction_lines_gt.applied_from_trx_id%TYPE;
6944: l_applied_from_line_id zx_transaction_lines_gt.applied_from_line_id%TYPE;
6945:

Line 7757: ap_invoices_all ai

7753: SELECT aerd.code_combination_id
7754: INTO l_inv_line_list(i).default_dist_ccid
7755: FROM ap_exp_report_dists_all aerd,
7756: ap_expense_report_lines_all aerl,
7757: ap_invoices_all ai
7758: WHERE aerd.report_header_id = l_inv_line_list(i).reference_key1
7759: AND aerd.report_line_id = l_inv_line_list(i).reference_key2
7760: AND aerd.report_line_id = aerl.report_line_id
7761: AND aerd.report_header_id = aerl.report_header_id

Line 8703: ap_invoices_all ai

8699: SELECT aerd.code_combination_id
8700: INTO l_default_ccid
8701: FROM ap_exp_report_dists_all aerd,
8702: ap_expense_report_lines_all aerl,
8703: ap_invoices_all ai
8704: WHERE aerd.report_header_id = P_Inv_Line_List(i).reference_key1
8705: AND aerd.report_line_id = P_Inv_Line_List(i).reference_key2
8706: AND aerd.report_line_id = aerl.report_line_id
8707: AND aerd.report_header_id = aerl.report_header_id

Line 9994: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

9990: | 06-FEB-2004 SYIDNER Created
9991: |
9992: *============================================================================*/
9993: FUNCTION Populate_Tax_Lines_GT(
9994: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
9995: P_Calling_Mode IN VARCHAR2,
9996: P_Event_Class_Code IN VARCHAR2,
9997: P_Tax_only_Flag IN VARCHAR2,
9998: P_Inv_Rcv_Matched IN OUT NOCOPY VARCHAR2,

Line 11007: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

11003: |
11004: *============================================================================*/
11005:
11006: FUNCTION Populate_Distributions_GT(
11007: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
11008: P_Calling_Mode IN VARCHAR2,
11009: P_Event_Class_Code IN VARCHAR2,
11010: P_Event_Type_Code IN VARCHAR2,
11011: P_Error_Code OUT NOCOPY VARCHAR2,

Line 11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;

11053: -- Prepayment Info
11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;

Line 11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;

11054: l_prepay_doc_application_id zx_transaction_lines_gt.applied_from_application_id%TYPE;
11055: l_prepay_doc_entity_code zx_transaction_lines_gt.applied_from_entity_code%TYPE;
11056: l_prepay_doc_event_class_code zx_transaction_lines_gt.applied_from_event_class_code%TYPE;
11057: l_prepay_doc_number ap_invoices_all.invoice_num%TYPE;
11058: l_prepay_doc_date ap_invoices_all.invoice_date%TYPE;
11059: l_applied_from_trx_id ap_invoice_lines_all.invoice_id%TYPE;
11060: l_applied_from_line_id ap_invoice_lines_all.line_number%TYPE;
11061: l_applied_from_trx_level_type zx_transaction_lines_gt.applied_from_trx_level_type%TYPE;
11062:

Line 11663: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,

11659: |
11660: *============================================================================*/
11661:
11662: FUNCTION Update_AP(
11663: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,
11664: P_Calling_Mode IN VARCHAR2,
11665: P_All_Error_Messages IN VARCHAR2,
11666: P_Error_Code OUT NOCOPY VARCHAR2,
11667: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN

Line 11831: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

11827: | 13-AUG-2004 Sanjay Created
11828: *============================================================================*/
11829:
11830: FUNCTION CALCULATE_QUOTE(
11831: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
11832: P_Invoice_Lines_Rec IN ap_invoice_lines_all%ROWTYPE,
11833: P_Calling_Mode IN VARCHAR2,
11834: P_Tax_Amount OUT NOCOPY NUMBER,
11835: P_Tax_Amt_Included OUT NOCOPY VARCHAR2,

Line 13399: l_inv_header_rec ap_invoices_all%ROWTYPE;

13395:
13396:
13397: l_tax_already_calculated VARCHAR2(1) :='N';
13398:
13399: l_inv_header_rec ap_invoices_all%ROWTYPE;
13400: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
13401: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
13402:
13403: l_transaction_rec zx_api_pub.transaction_rec_type;

Line 13411: FROM ap_invoices_all

13407:
13408:
13409: CURSOR Invoice_Header IS
13410: SELECT *
13411: FROM ap_invoices_all
13412: WHERE invoice_id = P_Invoice_Id;
13413:
13414: CURSOR Invoice_Lines IS
13415: SELECT *

Line 14157: UPDATE ap_invoices_all ai

14153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, l_debug_info);
14154: END IF;
14155: END IF;
14156:
14157: UPDATE ap_invoices_all ai
14158: SET (ai.total_tax_amount,
14159: ai.self_assessed_tax_amount) =
14160: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14161: 'N', NVL(zls.tax_amt, 0),0)),

Line 15893: FROM ap_invoices_all

15889: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
15890:
15891: CURSOR invoice_header IS
15892: SELECT *
15893: FROM ap_invoices_all
15894: WHERE invoice_id = P_Invoice_Id;
15895:
15896: CURSOR prepay_lines IS
15897: SELECT distinct prepLine.*

Line 15908: l_inv_header_rec ap_invoices_all%ROWTYPE;

15904: AND invDist.line_type_lookup_code = 'PREPAY'
15905: AND invDist.invoice_id = p_invoice_id
15906: AND invDist.invoice_line_number = p_invoice_line_number;
15907:
15908: l_inv_header_rec ap_invoices_all%ROWTYPE;
15909: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
15910: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
15911:
15912: l_tax_already_calculated VARCHAR2(1);

Line 16154: l_invoice_header_rec ap_invoices_all%rowtype;

16150:
16151: -- Removed the cursor for the bug 9749258
16152:
16153:
16154: l_invoice_header_rec ap_invoices_all%rowtype;
16155: l_application_id zx_trx_headers_gt.application_id%TYPE;
16156: l_entity_code zx_trx_headers_gt.entity_code%TYPE;
16157: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
16158: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;

Line 16199: From ap_invoices_all

16195: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16196: END IF;
16197: -------------------------------------------------------------------
16198: Select * Into l_invoice_header_rec
16199: From ap_invoices_all
16200: Where invoice_id = p_invoice_id;
16201:
16202: IF ((l_invoice_header_rec.quick_credit = 'Y') OR -- Bug 5660314
16203: (l_invoice_header_rec.invoice_type_lookup_code IN ('AWT', 'INTEREST'))) THEN

Line 16563: l_inv_header_rec ap_invoices_all%ROWTYPE;

16559:
16560: l_debug_info VARCHAR2(240);
16561: l_curr_calling_sequence VARCHAR2(4000);
16562:
16563: l_inv_header_rec ap_invoices_all%ROWTYPE;
16564: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
16565: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
16566:
16567: l_tax_already_calculated VARCHAR2(1);

Line 16580: FROM ap_invoices_all

16576: l_inv_rcv_matched VARCHAR2(1) := 'N';
16577:
16578: CURSOR Invoice_Header IS
16579: SELECT *
16580: FROM ap_invoices_all
16581: WHERE invoice_id = P_Invoice_Id;
16582:
16583: CURSOR Tax_Lines_to_import IS
16584: SELECT *

Line 16766: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

16762:
16763: END Calculate_Tax_Receipt_Match;
16764:
16765: FUNCTION Populate_Rct_Match_Lines_GT(
16766: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
16767: P_Event_Class_Code IN VARCHAR2,
16768: P_Error_Code OUT NOCOPY VARCHAR2,
16769: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
16770:

Line 17334: FROM ap_invoices_all ai,

17330: ai.vendor_id, --bill_third_pty_acct_id
17331: ai.vendor_site_id, --bill_third_pty_acct_site_id
17332: ai.vendor_id, --ship_third_pty_acct_id
17333: ai.vendor_site_id --ship_third_pty_acct_site_id
17334: FROM ap_invoices_all ai,
17335: fnd_currencies cur,
17336: fnd_document_sequences doc,
17337: ap_invoices_all related_ai,
17338: ap_system_parameters_all asp --Bug14779241

Line 17337: ap_invoices_all related_ai,

17333: ai.vendor_site_id --ship_third_pty_acct_site_id
17334: FROM ap_invoices_all ai,
17335: fnd_currencies cur,
17336: fnd_document_sequences doc,
17337: ap_invoices_all related_ai,
17338: ap_system_parameters_all asp --Bug14779241
17339: WHERE ai.invoice_currency_code = cur.currency_code
17340: AND ai.doc_sequence_id = doc.doc_sequence_id (+)
17341: AND ai.tax_related_invoice_id = related_ai.invoice_id (+)

Line 17374: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,

17370:
17371: END Bulk_Populate_Headers_GT;
17372:
17373: FUNCTION Update_Distributions(
17374: P_Invoice_header_rec IN ap_invoices_all%ROWTYPE,
17375: P_Calling_Mode IN VARCHAR2,
17376: P_All_Error_Messages IN VARCHAR2,
17377: P_Error_Code OUT NOCOPY VARCHAR2,
17378: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN

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

17917:
17918: END Update_Distributions;
17919:
17920: PROCEDURE Cache_Line_Defaults
17921: (p_org_id IN ap_invoices_all.org_id%type,
17922: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
17923: p_calling_sequence IN VARCHAR2) IS
17924:
17925: l_api_name VARCHAR2(30) := 'Cache_Line_Defaults';

Line 18007: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,

18003: APP_EXCEPTION.RAISE_EXCEPTION;
18004: END Cache_Line_Defaults;
18005:
18006: FUNCTION Return_Other_Charge_Lines(
18007: P_Invoice_Header_Rec IN ap_invoices_all%ROWTYPE,
18008: P_Error_Code OUT NOCOPY VARCHAR2,
18009: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
18010: IS
18011:

Line 18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
18026: l_payment_priority ap_batches_all.payment_priority%TYPE;
18027:
18028: l_total_tax_amount NUMBER;
18029: l_self_assessed_tax_amt NUMBER;

Line 18555: FROM ap_invoices_all ai,

18551: zls.tax_rate_id, -- tax_rate_id
18552: zls.tax_rate_code, -- tax_rate_code
18553: zls.tax_rate, -- tax_rate
18554: null -- tax_code_id
18555: FROM ap_invoices_all ai,
18556: ap_suppliers ap,
18557: ap_supplier_sites_all aps,
18558: zx_lines_summary zls,
18559: ap_invoice_lines_all prepay

Line 18641: UPDATE ap_invoices_all ai

18637: END IF;
18638: -------------------------------------------------------------------
18639: /*Bug 8638881 added CASE in the below SQL to consider the case of invoice includes prepay*/
18640: BEGIN
18641: UPDATE ap_invoices_all ai
18642: SET (ai.total_tax_amount,
18643: ai.self_assessed_tax_amount) =
18644: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
18645: 'N', case when exists (SELECT 'Prepay App Exists'

Line 18763: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%type;

18759: l_sync_trx_lines_t ZX_API_PUB.sync_trx_lines_tbl_type%type;
18760:
18761: --Bug8975892
18762:
18763: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%type;
18764: l_quick_credit AP_INVOICES_ALL.quick_credit%type;
18765: l_credited_invoice_id AP_INVOICES_ALL.credited_invoice_id%type;
18766: l_credited_inv_rec AP_INVOICES_ALL%ROWTYPE;
18767:

Line 18764: l_quick_credit AP_INVOICES_ALL.quick_credit%type;

18760:
18761: --Bug8975892
18762:
18763: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%type;
18764: l_quick_credit AP_INVOICES_ALL.quick_credit%type;
18765: l_credited_invoice_id AP_INVOICES_ALL.credited_invoice_id%type;
18766: l_credited_inv_rec AP_INVOICES_ALL%ROWTYPE;
18767:
18768: --Bug8975892

Line 18765: l_credited_invoice_id AP_INVOICES_ALL.credited_invoice_id%type;

18761: --Bug8975892
18762:
18763: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%type;
18764: l_quick_credit AP_INVOICES_ALL.quick_credit%type;
18765: l_credited_invoice_id AP_INVOICES_ALL.credited_invoice_id%type;
18766: l_credited_inv_rec AP_INVOICES_ALL%ROWTYPE;
18767:
18768: --Bug8975892
18769:

Line 18766: l_credited_inv_rec AP_INVOICES_ALL%ROWTYPE;

18762:
18763: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%type;
18764: l_quick_credit AP_INVOICES_ALL.quick_credit%type;
18765: l_credited_invoice_id AP_INVOICES_ALL.credited_invoice_id%type;
18766: l_credited_inv_rec AP_INVOICES_ALL%ROWTYPE;
18767:
18768: --Bug8975892
18769:
18770:

Line 18816: FROM ap_invoices_all ai

18812: , ai.tax_invoice_internal_seq tax_invoice_number
18813: , ai.invoice_type_lookup_code
18814: , ai.quick_credit
18815: , ai.credited_invoice_id
18816: FROM ap_invoices_all ai
18817: , fnd_document_sequences doc
18818: WHERE ai.invoice_id=p_invoice_id
18819: AND ai.doc_sequence_id=doc.doc_sequence_id (+);
18820: