APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on AP_RETRO_PRICING_PKG

Line 506: p_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

502: FUNCTION Corrections_Exists(
503: p_invoice_id IN NUMBER,
504: p_line_number IN NUMBER,
505: p_line_type_lookup_code IN VARCHAR2,
506: p_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
507: p_corrections_exist OUT NOCOPY VARCHAR2 )
508: RETURN BOOLEAN IS
509:
510: CURSOR corr_lines IS

Line 758: p_tax_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

754: *============================================================================*/
755: FUNCTION Tipv_Exists(
756: p_invoice_id IN NUMBER,
757: p_invoice_line_number IN NUMBER,
758: p_tax_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
759: p_tipv_exist OUT NOCOPY VARCHAR2)
760: RETURN BOOLEAN IS
761:
762: CURSOR tax_lines IS

Line 1356: p_lines_rec IN AP_RETRO_PRICING_PKG.invoice_lines_rec_type,

1352: | 29-JUL-2003 dgulraja Creation
1353: |
1354: *==========================================================================*/
1355: FUNCTION Create_Line(
1356: p_lines_rec IN AP_RETRO_PRICING_PKG.invoice_lines_rec_type,
1357: P_calling_sequence IN VARCHAR2)
1358: RETURN BOOLEAN IS
1359:
1360: debug_info VARCHAR2(1000);

Line 1681: p_base_match_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,

1677: *==========================================================================*/
1678: FUNCTION Get_Base_Match_Lines(
1679: p_instruction_id IN NUMBER,
1680: p_instruction_line_id IN NUMBER,
1681: p_base_match_lines_list OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_lines_list_type,
1682: P_calling_sequence IN VARCHAR2)
1683: RETURN BOOLEAN IS
1684:
1685: current_calling_sequence VARCHAR2(1000);

Line 1861: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Get_Base_Match_Lines'

1857: AND L.generate_dists = 'D';
1858:
1859: BEGIN
1860: --
1861: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Get_Base_Match_Lines'
1862: ||P_Calling_Sequence;
1863:
1864: debug_info := 'Open base_match_lines';
1865: OPEN base_match_lines;

Line 1917: p_ppa_invoice_rec OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_rec_type,

1913: p_instruction_id IN NUMBER,
1914: p_invoice_id IN NUMBER, --Base match line's invoice_id
1915: p_line_number IN NUMBER, --Base match line number
1916: p_batch_id IN NUMBER,
1917: p_ppa_invoice_rec OUT NOCOPY AP_RETRO_PRICING_PKG.invoice_rec_type,
1918: P_calling_sequence IN VARCHAR2)
1919: RETURN BOOLEAN IS
1920: CURSOR ppa_header
1921: IS

Line 2070: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;

2066: AND AI.invoice_id = p_invoice_id; -- base_match_lines_rec.invoice_id
2067:
2068: l_new_ppa_count NUMBER;
2069: l_existing_ppa_count NUMBER;
2070: l_ppa_invoice_rec AP_RETRO_PRICING_PKG.invoice_rec_type;
2071: l_description AP_INVOICES_ALL.description%TYPE;
2072: l_dbseqnm VARCHAR2(30);
2073: l_seqassid NUMBER;
2074: l_seq_num_profile VARCHAR2(80);

Line 2082: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Create_ppa_Invoice'

2078:
2079:
2080: BEGIN
2081:
2082: current_calling_sequence := 'AP_RETRO_PRICING_PKG.Create_ppa_Invoice'
2083: ||P_Calling_Sequence;
2084: ---------------------------------------------
2085: debug_info := 'Create_Ppa_Invoice Step :1 Open cursor ppa_header';
2086: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then