APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_RETRO_PRICING_PKG

Line 510: p_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

506: FUNCTION Corrections_Exists(
507: p_invoice_id IN NUMBER,
508: p_line_number IN NUMBER,
509: p_match_ype IN VARCHAR2, --p_line_type_lookup_code bug#9573078
510: p_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
511: p_corrections_exist OUT NOCOPY VARCHAR2 )
512: RETURN BOOLEAN IS
513:
514: CURSOR corr_lines IS

Line 763: p_tax_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

759: *============================================================================*/
760: FUNCTION Tipv_Exists(
761: p_invoice_id IN NUMBER,
762: p_invoice_line_number IN NUMBER,
763: p_tax_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
764: p_tipv_exist OUT NOCOPY VARCHAR2)
765: RETURN BOOLEAN IS
766:
767: CURSOR tax_lines IS

Line 1391: p_lines_rec IN AP_RETRO_PRICING_PKG.invoice_lines_rec_type,

1387: | 29-JUL-2003 dgulraja Creation
1388: |
1389: *==========================================================================*/
1390: FUNCTION Create_Line(
1391: p_lines_rec IN AP_RETRO_PRICING_PKG.invoice_lines_rec_type,
1392: P_calling_sequence IN VARCHAR2)
1393: RETURN BOOLEAN IS
1394:
1395: debug_info VARCHAR2(1000);

Line 1716: p_base_match_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

1712: *==========================================================================*/
1713: FUNCTION Get_Base_Match_Lines(
1714: p_instruction_id IN NUMBER,
1715: p_instruction_line_id IN NUMBER,
1716: p_base_match_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
1717: P_calling_sequence IN VARCHAR2)
1718: RETURN BOOLEAN IS
1719:
1720: current_calling_sequence VARCHAR2(1000);

Line 1897: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Get_Base_Match_Lines'

1893: ORDER BY L.invoice_id; --Added for bug#9855094
1894:
1895: BEGIN
1896: --
1897: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Get_Base_Match_Lines'
1898: ||P_Calling_Sequence;
1899:
1900: debug_info := 'Open base_match_lines';
1901: OPEN base_match_lines;

Line 1953: p_ppa_invoice_rec OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_rec_type,

1949: p_instruction_id IN NUMBER,
1950: p_invoice_id IN NUMBER, --Base match line's invoice_id
1951: p_line_number IN NUMBER, --Base match line number
1952: p_batch_id IN NUMBER,
1953: p_ppa_invoice_rec OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_rec_type,
1954: P_calling_sequence IN VARCHAR2)
1955: RETURN BOOLEAN IS
1956: CURSOR ppa_header
1957: IS

Line 2107: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;

2103:
2104: l_new_ppa_count NUMBER;
2105: l_existing_ppa_count NUMBER;
2106: l_temp_ppa_count NUMBER; --bug#9855094
2107: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;
2108: l_description AP_INVOICES_ALL.description%TYPE;
2109: l_dbseqnm VARCHAR2(30);
2110: l_seqassid NUMBER;
2111: l_seq_num_profile VARCHAR2(80);

Line 2119: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Create_ppa_Invoice'

2115:
2116:
2117: BEGIN
2118:
2119: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Create_ppa_Invoice'
2120: ||P_Calling_Sequence;
2121: ---------------------------------------------
2122: debug_info := 'Create_Ppa_Invoice Step :1 Open cursor ppa_header';
2123: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then