DBA Data[Home] [Help]

APPS.AP_ALLOCATION_RULES_PKG dependencies on AP_ALLOCATION_RULES_PKG

Line 1: PACKAGE BODY AP_ALLOCATION_RULES_PKG as

1: PACKAGE BODY AP_ALLOCATION_RULES_PKG as
2: /* $Header: apalocrb.pls 120.13 2007/12/05 18:43:29 gagrawal ship $ */
3:
4: -----------------------------------------------------------------------
5: -- FUNCTION insert_fully_prorated creates an PRORATION type allocation

Line 23: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||

19: BEGIN
20:
21: -- Update the calling sequence
22:
23: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||
24: 'insert_fully_prorated_rule';
25: --------------------------------------------------------------
26: -- Step 1 - Verify line exists, has generate_dists flag
27: -- set to Y

Line 155: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||

151: debug_info VARCHAR2(200);
152: BEGIN
153:
154: -- Update the calling sequence
155: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||
156: 'insert_from_prorated_rule';
157: --------------------------------------------------------------
158: -- Step 1 - Verify line exists, has generate_dists flag
159: -- set to Y

Line 572: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||

568:
569: BEGIN
570:
571: -- Update the calling sequence
572: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||
573: 'Create_Allocations';
574:
575: --------------------------------------------------------------
576: debug_info := ' Step 1 - Verify IF any chrg line exists for '

Line 613: IF (NOT (Ap_Allocation_Rules_Pkg.Create_Proration_Rule(

609: l_chrg_line_number;
610:
611: EXIT WHEN chrg_lines_cur%NOTFOUND;
612:
613: IF (NOT (Ap_Allocation_Rules_Pkg.Create_Proration_Rule(
614: l_invoice_id,
615: l_chrg_line_number,
616: NULL, -- rule_type
617: X_Window_context, --

Line 689: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||

685: BEGIN
686:
687: -- Update the calling sequence
688:
689: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||
690: 'Create_Proration_Rule';
691: --------------------------------------------------------------
692: debug_info := ' Step 1 - Verify IF any chrg line exists for '
693: ||'this Invoice';

Line 817: Ap_Allocation_Rules_Pkg.delete_allocation_lines(

813:
814: IF (l_rule_type ='PRORATION') THEN
815: l_create_alloc_rule_lines := 'Y';
816: IF l_alloc_rule_lines <> 0 then
817: Ap_Allocation_Rules_Pkg.delete_allocation_lines(
818: X_invoice_id,
819: X_chrg_Line_number,
820: 'Insert_fully_prorated_rule');
821: END IF;

Line 1161: 'Ap_Allocation_Rules_Pkg.select_Item_summary<-'||X_Calling_Sequence;

1157: BEGIN
1158: -- Update the calling sequence
1159: --
1160: current_calling_sequence :=
1161: 'Ap_Allocation_Rules_Pkg.select_Item_summary<-'||X_Calling_Sequence;
1162: ----------------------------------------------------------
1163: debug_info := 'Get allocated total';
1164: ----------------------------------------------------------
1165:

Line 1229: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||

1225:
1226: BEGIN
1227:
1228: -- Update the calling sequence
1229: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||
1230: 'Allocation_Rule_Lines';
1231:
1232: --------------------------------------------------------------
1233: debug_info := ' Step 1 - Verify IF allocation rule line exists';

Line 1408: 'Ap_Allocation_Rules_Pkg.form_startup<-'||X_Calling_Sequence;

1404: BEGIN
1405: -- Update the calling sequence
1406: --
1407: current_calling_sequence :=
1408: 'Ap_Allocation_Rules_Pkg.form_startup<-'||X_Calling_Sequence;
1409:
1410: --------------------------------------------------------------
1411: debug_info := 'Get invoice information';
1412: --------------------------------------------------------------

Line 1476: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.Update_Row<-'

1472: debug_info VARCHAR2(100);
1473:
1474: BEGIN
1475:
1476: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.Update_Row<-'
1477: ||X_Calling_Sequence;
1478:
1479: -- Check for uniqueness of the lineine number
1480:

Line 1542: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.Lock_Row<-'

1538:
1539: BEGIN
1540: -- Update the calling sequence
1541: --
1542: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.Lock_Row<-'
1543: ||X_Calling_Sequence;
1544:
1545: --------------------------------------------------------------
1546: debug_info := 'Select from ap_allocation_rules';

Line 1657: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||

1653:
1654: BEGIN
1655:
1656: -- Update the calling sequence
1657: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||
1658: 'Prorate_allocated_lines';
1659: --------------------------------------------------------------
1660: debug_info := 'Step 1 - Verify chrg line exists, has '
1661: ||' generate_dists flag set to Y';

Line 1914: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||

1910:
1911: BEGIN
1912:
1913: -- Update the calling sequence
1914: current_calling_sequence := 'Ap_Allocation_Rules_Pkg.'||
1915: 'Delete_Allocations';
1916: --------------------------------------------------------------
1917: debug_info := 'Step 1 - Verify chrg line exists, has '
1918: ||' generate_dists flag set to Y';

Line 2020: Ap_Allocation_Rules_Pkg.Delete_Allocation_Lines(

2016: WHERE invoice_id = X_Invoice_Id
2017: AND chrg_invoice_line_number = X_chrg_line_number;
2018:
2019: IF l_rule_type <> 'PRORATION' THEN
2020: Ap_Allocation_Rules_Pkg.Delete_Allocation_Lines(
2021: X_invoice_id => X_Invoice_Id,
2022: X_chrg_line_number => X_chrg_line_number,
2023: X_calling_sequence => current_calling_sequence);
2024: END IF;

Line 2050: 'Ap_Allocation_Rules_Pkg.Delete_allocations_lines<-'||X_Calling_Sequence;

2046: debug_info VARCHAR2(100);
2047:
2048: BEGIN
2049: current_calling_sequence :=
2050: 'Ap_Allocation_Rules_Pkg.Delete_allocations_lines<-'||X_Calling_Sequence;
2051: -----------------------------------------------------------
2052: debug_info := 'Deleting any existing allocation rows ';
2053: ----------------------------------------------------------
2054: DELETE FROM ap_allocation_rule_lines

Line 2098: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||

2094:
2095: BEGIN
2096:
2097: -- Update the calling sequence
2098: current_calling_sequence := 'AP_ALLOCATION_RULES_PKG.'||
2099: 'insert_tax_allocations';
2100:
2101: --------------------------------------------------------------
2102: -- Step 1 - Verify line exists, has generate_dists flag

Line 2291: END AP_ALLOCATION_RULES_PKG;

2287: RETURN(TRUE);
2288:
2289: END insert_tax_allocations;
2290:
2291: END AP_ALLOCATION_RULES_PKG;