APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_ITEMS

Line 80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE

76: );
77:
78: /* A Record to hold all the neccessary attributes for exporting */
79: TYPE exp_ar_rec IS RECORD (
80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE

Line 81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE

77:
78: /* A Record to hold all the neccessary attributes for exporting */
79: TYPE exp_ar_rec IS RECORD (
80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE

Line 82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE

78: /* A Record to hold all the neccessary attributes for exporting */
79: TYPE exp_ar_rec IS RECORD (
80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE

Line 83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE

79: TYPE exp_ar_rec IS RECORD (
80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE

Line 84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE

80: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE

Line 85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE

81: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
82: ,pn_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE
83: ,pn_export_currency_amount PN_PAYMENT_ITEMS.export_currency_amount%TYPE
84: ,pn_customer_id PN_PAYMENT_ITEMS.customer_id%TYPE
85: ,pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE
86: ,pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE
87: ,pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE
88: ,pn_tax_classification_code PN_PAYMENT_TERMS.tax_classification_code%TYPE
89: ,pn_legal_entity_id PN_PAYMENT_TERMS.legal_entity_id%TYPE

Line 106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE

102: ,pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE
103: ,pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE
104: ,pn_org_id PN_PAYMENT_TERMS.org_id%TYPE
105: ,pn_lease_num PN_LEASES.lease_num%TYPE
106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE
109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE

Line 110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE

106: ,pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE
107: ,pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE
108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE
109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE
111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE
112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
113: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
114: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE

Line 112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE

108: ,pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE
109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE
111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE
112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
113: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
114: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE
115: ,send_entries PN_LEASE_DETAILS.send_entries%TYPE
116: ,rec_account PN_DISTRIBUTIONS.account_id%TYPE

Line 113: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE

109: ,pn_lease_id PN_LEASES.lease_id%TYPE
110: ,transaction_date PN_PAYMENT_ITEMS.due_date%TYPE
111: ,normalize PN_PAYMENT_TERMS.normalize%TYPE
112: ,pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE
113: ,pn_rate PN_PAYMENT_ITEMS.rate%TYPE
114: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE
115: ,send_entries PN_LEASE_DETAILS.send_entries%TYPE
116: ,rec_account PN_DISTRIBUTIONS.account_id%TYPE
117: ,gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE

Line 119: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE

115: ,send_entries PN_LEASE_DETAILS.send_entries%TYPE
116: ,rec_account PN_DISTRIBUTIONS.account_id%TYPE
117: ,gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE
118: ,conv_rate_type PN_CURRENCIES.conversion_type%TYPE
119: ,conv_rate PN_PAYMENT_ITEMS.rate%TYPE
120: ,set_of_books_id NUMBER
121: ,payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE
122: ,payment_type PN_PAYMENT_TERMS.payment_term_type_code%TYPE
123: ,rule_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE

Line 131: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE

127: /* Declare a PL/SQL table of above record */
128: TYPE exp_ar_tbl_type IS TABLE OF exp_ar_rec INDEX BY BINARY_INTEGER;
129:
130: TYPE err_ar_rec is RECORD (
131: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
132: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
133: ,pn_lease_num PN_LEASES.lease_num%TYPE
134: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE
135: );

Line 132: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE

128: TYPE exp_ar_tbl_type IS TABLE OF exp_ar_rec INDEX BY BINARY_INTEGER;
129:
130: TYPE err_ar_rec is RECORD (
131: pn_payment_item_id PN_PAYMENT_ITEMS.payment_item_id%TYPE
132: ,pn_payment_term_id PN_PAYMENT_ITEMS.payment_term_id%TYPE
133: ,pn_lease_num PN_LEASES.lease_num%TYPE
134: ,location_id PN_LOCATIONS.LOCATION_ID%TYPE
135: );
136: