APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_ITEMS

Line 60: (org_id PN_PAYMENT_ITEMS.org_id%TYPE

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

Line 61: ,pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE

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

Line 62: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE

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

Line 63: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%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

Line 64: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE

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

Line 65: ,pn_vendor_id PN_PAYMENT_ITEMS.vendor_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

Line 66: ,pn_vendor_site_id PN_PAYMENT_ITEMS.vendor_site_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

Line 80: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%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

Line 84: ,pn_due_date PN_PAYMENT_ITEMS.due_date%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

Line 86: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%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

Line 87: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE

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

Line 88: ,pn_ap_invoice_num PN_PAYMENT_ITEMS.ap_invoice_num%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

Line 93: ,conv_rate PN_PAYMENT_ITEMS.rate%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

Line 95: ,item_grouping_rule_id PN_PAYMENT_ITEMS.grouping_rule_id%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: