[Home] [Help]
PACKAGE: APPS.PN_EXP_TO_AP
Source
1 package PN_EXP_TO_AP AUTHID CURRENT_USER as
2 -- $Header: PNTXPMTS.pls 120.5 2005/12/01 11:17:31 hrodda ship $
3
4 FUNCTION get_liability_acc(p_payment_term_id NUMBER
5 ,p_vendor_id NUMBER
6 ,p_vendor_site_id NUMBER) RETURN NUMBER;
7
8 PROCEDURE populate_group_by_flags(p_grouping_rule_id IN NUMBER);
9
10 PROCEDURE get_order_by_grpby;
11
12 PROCEDURE cache_exp_items(
13 p_lease_num_low VARCHAR2,
14 p_lease_num_high VARCHAR2,
15 p_sch_dt_low VARCHAR2,
16 p_sch_dt_high VARCHAR2,
17 p_due_dt_low VARCHAR2,
18 p_due_dt_high VARCHAR2,
19 p_pay_prps_code VARCHAR2,
20 p_prd_name VARCHAR2,
21 p_amt_low NUMBER,
22 p_amt_high NUMBER,
23 p_vendor_id NUMBER,
24 p_inv_num VARCHAR2,
25 p_grp_param VARCHAR2);
26
27 PROCEDURE group_and_export_items(errbuf IN OUT NOCOPY VARCHAR2
28 ,retcode IN OUT NOCOPY NUMBER
29 ,p_group_id VARCHAR2
30 ,p_param_where_clause VARCHAR2 DEFAULT NULL);
31
32 PROCEDURE export_items_nogrp(errbuf IN OUT NOCOPY VARCHAR2
33 ,retcode IN OUT NOCOPY NUMBER
34 ,p_group_id VARCHAR2
35 ,p_param_where_clause VARCHAR2 DEFAULT NULL);
36
37 -------------------------------------------------------------------
38 -- For loading PN's Invoice Info into AP's Interface Tables
39 -- ( Run as a Conc Process )
40 -------------------------------------------------------------------
41
42 PROCEDURE exp_to_ap(errbuf OUT NOCOPY VARCHAR2
43 ,retcode OUT NOCOPY NUMBER
44 ,p_lease_num_low VARCHAR2
45 ,p_lease_num_high VARCHAR2
46 ,p_sch_dt_low VARCHAR2
47 ,p_sch_dt_high VARCHAR2
48 ,p_due_dt_low VARCHAR2
49 ,p_due_dt_high VARCHAR2
50 ,p_pay_prps_code VARCHAR2
51 ,p_prd_name VARCHAR2
52 ,p_amt_low NUMBER
53 ,p_amt_high NUMBER
54 ,p_vendor_id NUMBER
55 ,p_inv_num VARCHAR2
56 ,p_grp_param VARCHAR2 DEFAULT NULL);
57
58 -- export to AP record type
59 TYPE exp_ap_rec_typ IS RECORD
60 (org_id PN_PAYMENT_ITEMS.org_id%TYPE
61 ,pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
62 ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
63 ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
64 ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
65 ,pn_vendor_id PN_PAYMENT_ITEMS.vendor_id%TYPE
66 ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_id%TYPE
67 ,pn_project_id PN_PAYMENT_TERMS.project_id%TYPE
68 ,pn_task_id PN_PAYMENT_TERMS.task_id%TYPE
69 ,pn_organization_id PN_PAYMENT_TERMS.organization_id%TYPE
70 ,pn_expenditure_type PN_PAYMENT_TERMS.expenditure_type%TYPE
71 ,pn_expenditure_item_date PN_PAYMENT_TERMS.expenditure_item_date%TYPE
72 ,pn_tax_group_id PN_PAYMENT_TERMS.tax_group_id%TYPE
73 ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
74 ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
75 ,pn_tax_included PN_PAYMENT_TERMS.tax_included%TYPE
76 ,pn_distribution_set_id PN_PAYMENT_TERMS.distribution_set_id%TYPE
77 ,pn_lease_num PN_LEASES.lease_num%TYPE
78 ,pn_lease_id PN_LEASES.lease_id%TYPE
79 ,pn_send_entries PN_LEASE_DETAILS.send_entries%TYPE
80 ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
81 ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
82 ,gl_date DATE
83 ,pn_normalize PN_PAYMENT_TERMS.normalize%TYPE
84 ,pn_due_date PN_PAYMENT_ITEMS.due_date%TYPE
85 ,pn_ap_ar_term_id PN_PAYMENT_TERMS.ap_ar_term_id%TYPE
86 ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
87 ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
88 ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%TYPE
89 ,pn_payment_purpose_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE
90 ,pn_payment_term_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE
91 ,pn_lia_account PN_DISTRIBUTIONS.account_id%TYPE
92 ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE
93 ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
94 ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
95 ,item_grouping_rule_id PN_PAYMENT_ITEMS.grouping_rule_id%TYPE
96 ,term_grouping_rule_id PN_PAYMENT_TERMS.grouping_rule_id%TYPE
97 ,lease_grouping_rule_id PN_LEASE_DETAILS.grouping_rule_id%TYPE
98 ,processed VARCHAR2(1));
99
100 -- export items cache table type
101 TYPE exp_ap_tbl_typ IS TABLE OF exp_ap_rec_typ INDEX BY BINARY_INTEGER;
102
103 END PN_EXP_TO_AP;