DBA Data[Home] [Help]

APPS.AP_ALLOCATION_RULES_PKG dependencies on AP_INVOICE_LINES

Line 15: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

11: X_line_number IN NUMBER,
12: X_error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
13: IS
14:
15: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
16: l_other_alloc_rules NUMBER;
17: current_calling_sequence VARCHAR2(2000);
18: debug_info VARCHAR2(200);
19: BEGIN

Line 32: FROM ap_invoice_lines

28: --------------------------------------------------------------
29: BEGIN
30: SELECT generate_dists
31: INTO l_generate_dists
32: FROM ap_invoice_lines
33: WHERE invoice_id = X_invoice_id
34: AND line_number = X_line_number;
35:
36: /* Bug 5131721 */

Line 142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

138: X_line_number IN NUMBER,
139: X_error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
140: IS
141:
142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;

139: X_error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
140: IS
141:
142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
147: l_count_non_item_lines NUMBER := 0;

Line 144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;

140: IS
141:
142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
147: l_count_non_item_lines NUMBER := 0;
148: l_prorating_total NUMBER := 0;

Line 145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

141:
142: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
143: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
144: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
145: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
146: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
147: l_count_non_item_lines NUMBER := 0;
148: l_prorating_total NUMBER := 0;
149: l_other_alloc_rules NUMBER;

Line 170: FROM ap_invoice_lines ail,

166: INTO l_generate_dists,
167: l_line_group_number,
168: l_amount_to_prorate,
169: l_inv_curr_code
170: FROM ap_invoice_lines ail,
171: ap_invoices ai
172: WHERE ail.invoice_id = X_invoice_id
173: AND ail.line_number = x_line_number
174: AND ai.invoice_id = X_invoice_id;

Line 203: FROM ap_invoice_lines

199: --------------------------------------------------------------
200: BEGIN
201: SELECT COUNT(*)
202: INTO l_count_non_item_lines
203: FROM ap_invoice_lines
204: WHERE invoice_id = X_invoice_id
205: AND line_number <> X_line_number
206: AND line_group_number = l_line_group_number
207: AND line_type_lookup_code <> 'ITEM';

Line 224: FROM ap_invoice_lines

220: --------------------------------------------------------------
221: BEGIN
222: SELECT SUM(amount)
223: INTO l_prorating_total
224: FROM ap_invoice_lines
225: WHERE invoice_id = X_invoice_id
226: AND line_number <> X_line_number
227: AND line_group_number = l_line_group_number
228: AND line_type_lookup_code = 'ITEM'

Line 351: FROM ap_invoice_lines

347: FND_GLOBAL.PROG_APPL_ID, -- program_application_id
348: FND_GLOBAL.CONC_PROGRAM_ID,-- program_id
349: SYSDATE, -- program_update_date
350: FND_GLOBAL.CONC_REQUEST_ID -- request_id
351: FROM ap_invoice_lines
352: WHERE invoice_id = X_invoice_id
353: AND line_number <> X_line_number
354: AND line_group_number = l_line_group_number
355: AND line_type_lookup_code = 'ITEM'

Line 392: FROM ap_invoice_lines ail1

388: WHERE invoice_id = X_invoice_id
389: AND chrg_invoice_line_number = X_line_number
390: AND to_invoice_line_number =
391: (SELECT (MAX(ail1.line_number))
392: FROM ap_invoice_lines ail1
393: WHERE ail1.invoice_id = X_invoice_id
394: AND ail1.line_number <> X_line_number
395: AND ail1.amount <> 0
396: AND ail1.line_group_number = l_line_group_number

Line 399: FROM ap_invoice_lines ail2

395: AND ail1.amount <> 0
396: AND ail1.line_group_number = l_line_group_number
397: AND ABS(ail1.amount) >=
398: ( SELECT MAX(ABS(ail2.amount))
399: FROM ap_invoice_lines ail2
400: WHERE ail2.invoice_id = X_invoice_id
401: AND ail2.line_number <> X_line_number
402: AND ail2.line_number <> ail1.line_number
403: AND ail2.line_group_number =

Line 554: FROM ap_invoice_lines

550:
551: CURSOR chrg_lines_cur IS
552: SELECT invoice_id,
553: line_number
554: FROM ap_invoice_lines
555: WHERE line_type_lookup_code in ('FREIGHT', 'MISCELLANEOUS')
556: AND generate_dists <> 'D' -- Bug 5131721
557: AND NVL(match_type, 'NOT_MATCHED') <> 'OTHER_TO_RECEIPT'
558: AND invoice_id = X_invoice_id

Line 562: l_invoice_id AP_INVOICE_LINES_ALL.Invoice_Id%TYPE;

558: AND invoice_id = X_invoice_id
559: ORDER BY line_number;
560:
561: l_chrg_lines_count BINARY_INTEGER := 0;
562: l_invoice_id AP_INVOICE_LINES_ALL.Invoice_Id%TYPE;
563: l_chrg_line_number AP_INVOICE_LINES_ALL.line_number%TYPE;
564: l_error_code VARCHAR2(30);
565: debug_info VARCHAR2(200);
566: debug_context VARCHAR2(2000);

Line 563: l_chrg_line_number AP_INVOICE_LINES_ALL.line_number%TYPE;

559: ORDER BY line_number;
560:
561: l_chrg_lines_count BINARY_INTEGER := 0;
562: l_invoice_id AP_INVOICE_LINES_ALL.Invoice_Id%TYPE;
563: l_chrg_line_number AP_INVOICE_LINES_ALL.line_number%TYPE;
564: l_error_code VARCHAR2(30);
565: debug_info VARCHAR2(200);
566: debug_context VARCHAR2(2000);
567: current_calling_sequence VARCHAR2(2000);

Line 583: FROM ap_invoice_lines

579: BEGIN
580:
581: SELECT COUNT(*)
582: INTO l_chrg_lines_count
583: FROM ap_invoice_lines
584: WHERE line_type_lookup_code in ('FREIGHT', 'MISCELLANEOUS', 'TAX')
585: AND generate_dists <> 'D' -- Bug 5131721
586: AND NVL(match_type, 'NOT_MATCHED') <> 'OTHER_TO_RECEIPT'
587: AND invoice_id = X_invoice_id;

Line 669: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

665: X_Debug_Context OUT NOCOPY VARCHAR2,
666: X_calling_sequence IN VARCHAR2)
667: RETURN BOOLEAN IS
668:
669: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
670: l_alloc_rule NUMBER;
671: l_alloc_rule_lines NUMBER;
672: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
673: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

Line 672: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;

668:
669: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
670: l_alloc_rule NUMBER;
671: l_alloc_rule_lines NUMBER;
672: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
673: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
674: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
675: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
676: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;

Line 673: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

669: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
670: l_alloc_rule NUMBER;
671: l_alloc_rule_lines NUMBER;
672: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
673: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
674: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
675: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
676: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
677: l_prorating_total NUMBER := 0;

Line 702: FROM ap_invoice_lines ail,

698: ai.invoice_currency_code
699: INTO l_generate_dists,
700: l_amount_to_prorate,
701: l_inv_curr_code
702: FROM ap_invoice_lines ail,
703: ap_invoices ai
704: WHERE ail.invoice_id = X_invoice_id
705: AND ail.line_number = x_chrg_line_number
706: AND ai.invoice_id = X_invoice_id;

Line 841: FROM ap_invoice_lines

837:
838: BEGIN
839: SELECT SUM(amount)
840: INTO l_prorating_total
841: FROM ap_invoice_lines
842: WHERE invoice_id = X_invoice_id
843: AND line_number <> X_chrg_line_number
844: AND line_type_lookup_code = 'ITEM'
845: AND nvl(match_type,'NOT_MATCHED') NOT IN

Line 957: FROM ap_invoice_lines

953: NULL, -- program_application_id
954: NULL, -- program_id
955: SYSDATE, -- program_update_date
956: NULL -- request_id
957: FROM ap_invoice_lines
958: WHERE invoice_id = X_invoice_id
959: AND line_number <> X_chrg_line_number
960: AND line_type_lookup_code = 'ITEM'
961: AND nvl(match_type,'NOT_MATCHED') NOT IN

Line 1012: FROM ap_invoice_lines

1008: NULL, -- program_application_id
1009: NULL, -- program_id
1010: SYSDATE, -- program_update_date
1011: NULL -- request_id
1012: FROM ap_invoice_lines
1013: WHERE invoice_id = X_invoice_id
1014: AND line_number <> X_chrg_line_number
1015: AND line_type_lookup_code = 'ITEM'
1016: AND nvl(match_type,'NOT_MATCHED') NOT IN

Line 1057: FROM ap_invoice_lines ail1

1053: WHERE invoice_id = X_invoice_id
1054: AND chrg_invoice_line_number = X_chrg_line_number
1055: AND to_invoice_line_number =
1056: (SELECT (MAX(ail1.line_number))
1057: FROM ap_invoice_lines ail1
1058: WHERE ail1.invoice_id = X_invoice_id
1059: AND ail1.line_number <> X_chrg_line_number
1060: AND ail1.amount <> 0
1061: AND ABS(ail1.amount) >=

Line 1063: FROM ap_invoice_lines ail2

1059: AND ail1.line_number <> X_chrg_line_number
1060: AND ail1.amount <> 0
1061: AND ABS(ail1.amount) >=
1062: ( SELECT MAX(ABS(ail2.amount))
1063: FROM ap_invoice_lines ail2
1064: WHERE ail2.invoice_id = X_invoice_id
1065: AND ail2.line_number <> X_chrg_line_number
1066: AND ail2.line_number <> ail1.line_number
1067: )

Line 1098: FROM ap_invoice_lines ail1

1094: WHERE invoice_id = X_invoice_id
1095: AND chrg_invoice_line_number = X_chrg_line_number
1096: AND to_invoice_line_number =
1097: (SELECT (MAX(ail1.line_number))
1098: FROM ap_invoice_lines ail1
1099: WHERE ail1.invoice_id = X_invoice_id
1100: AND ail1.line_number <> X_chrg_line_number
1101: AND ail1.amount <> 0
1102: AND ABS(ail1.amount) >=

Line 1104: FROM ap_invoice_lines ail2

1100: AND ail1.line_number <> X_chrg_line_number
1101: AND ail1.amount <> 0
1102: AND ABS(ail1.amount) >=
1103: ( SELECT MAX(ABS(ail2.amount))
1104: FROM ap_invoice_lines ail2
1105: WHERE ail2.invoice_id = X_invoice_id
1106: AND ail2.line_number <> X_chrg_line_number
1107: AND ail2.line_number <> ail1.line_number
1108: ));

Line 1220: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

1216: X_allocation_flag IN VARCHAR2,
1217: X_Error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
1218: IS
1219:
1220: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1221: l_alloc_rule_line NUMBER;
1222:
1223: debug_info VARCHAR2(100);
1224: current_calling_sequence VARCHAR2(2000);

Line 1640: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

1636: X_Debug_Context OUT NOCOPY VARCHAR2,
1637: X_calling_sequence IN VARCHAR2)
1638: RETURN BOOLEAN IS
1639:
1640: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1641: l_alloc_rule NUMBER;
1642: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1643: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1644: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 1642: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;

1638: RETURN BOOLEAN IS
1639:
1640: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1641: l_alloc_rule NUMBER;
1642: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1643: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1644: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1645: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1646: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;

Line 1643: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

1639:
1640: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1641: l_alloc_rule NUMBER;
1642: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1643: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1644: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1645: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1646: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
1647: l_prorating_total NUMBER := 0;

Line 1670: FROM ap_invoice_lines ail,

1666: ai.invoice_currency_code
1667: INTO l_generate_dists,
1668: l_amount_to_prorate,
1669: l_inv_curr_code
1670: FROM ap_invoice_lines ail,
1671: ap_invoices ai
1672: WHERE ail.invoice_id = X_invoice_id
1673: AND ail.line_number = x_chrg_line_number
1674: AND ai.invoice_id = X_invoice_id;

Line 1897: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

1893: X_Debug_Context OUT NOCOPY VARCHAR2,
1894: X_calling_sequence IN VARCHAR2)
1895: RETURN BOOLEAN IS
1896:
1897: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1898: l_alloc_rule NUMBER;
1899: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1900: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1901: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 1899: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;

1895: RETURN BOOLEAN IS
1896:
1897: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1898: l_alloc_rule NUMBER;
1899: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1900: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1901: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1902: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1903: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;

Line 1900: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

1896:
1897: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
1898: l_alloc_rule NUMBER;
1899: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
1900: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
1901: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
1902: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
1903: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
1904: l_prorating_total NUMBER := 0;

Line 1927: FROM ap_invoice_lines ail,

1923: ai.invoice_currency_code
1924: INTO l_generate_dists,
1925: l_amount_to_prorate,
1926: l_inv_curr_code
1927: FROM ap_invoice_lines ail,
1928: ap_invoices ai
1929: WHERE ail.invoice_id = X_invoice_id
1930: AND ail.line_number = x_chrg_line_number
1931: AND ai.invoice_id = X_invoice_id;

Line 2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;

2079: X_chrg_line_number IN NUMBER,
2080: X_error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2081: IS
2082:
2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

Line 2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;

2080: X_error_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2081: IS
2082:
2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2088: l_count_non_item_lines NUMBER := 0;

Line 2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;

2081: IS
2082:
2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2088: l_count_non_item_lines NUMBER := 0;
2089: l_prorating_total NUMBER := 0;

Line 2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;

2082:
2083: l_generate_dists AP_INVOICE_LINES.GENERATE_DISTS%TYPE;
2084: l_line_group_number AP_INVOICE_LINES.LINE_GROUP_NUMBER%TYPE;
2085: l_amount_to_prorate AP_INVOICE_LINES.AMOUNT%TYPE;
2086: l_total_prorated AP_INVOICE_LINES.AMOUNT%TYPE;
2087: l_inv_curr_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2088: l_count_non_item_lines NUMBER := 0;
2089: l_prorating_total NUMBER := 0;
2090: l_other_alloc_rules NUMBER;

Line 2114: FROM ap_invoice_lines ail,

2110: INTO l_generate_dists,
2111: l_line_group_number,
2112: l_amount_to_prorate,
2113: l_inv_curr_code
2114: FROM ap_invoice_lines ail,
2115: ap_invoices ai
2116: WHERE ail.invoice_id = x_invoice_id
2117: AND ail.line_number = x_chrg_line_number
2118: AND ai.invoice_id = ail.invoice_id;

Line 2260: ap_invoice_lines apl

2256: FND_GLOBAL.CONC_PROGRAM_ID, -- program_id
2257: SYSDATE, -- program_update_date
2258: FND_GLOBAL.CONC_REQUEST_ID -- request_id
2259: FROM zx_lines zxl,
2260: ap_invoice_lines apl
2261: WHERE apl.invoice_id = x_invoice_id
2262: AND apl.line_number = x_chrg_line_number
2263: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID