eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_PA_USER_EXITS dependencies on PA_TRANSACTION_INTERFACE

Line 9: The p_a_interface() logic will insert pay data to the PA_Transaction_Interface

5:
6: /*******************************************************************************
7: FUNCTION p_a_interface()
8:
9: The p_a_interface() logic will insert pay data to the PA_Transaction_Interface
10: table.Details to be inserted will be passed in as parameters to a function
11: called p_a_interface.Because the interface to Project Accounting will vary on
12: different installations,the p_a_interface logic will be stored in the
13: HXT_USER_EXITS package.HXT_USER_EXITS is designed to contain unique code,

Line 118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;

114: RETURN NUMBER IS
115:
116: -- Define local variables for each coloumn to ease customizations
117:
118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;
119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;

Line 119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;

115:
116: -- Define local variables for each coloumn to ease customizations
117:
118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;
119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;

Line 120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;

116: -- Define local variables for each coloumn to ease customizations
117:
118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;
119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;

Line 121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;

117:
118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;
119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;

Line 122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;

118: l_trans_source pa_transaction_interface.transaction_source%TYPE DEFAULT NULL;
119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;

Line 123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;

119: l_batch_name pa_transaction_interface.batch_name%TYPE DEFAULT NULL;
120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;

Line 124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;

120: l_employee_number pa_transaction_interface.employee_number%TYPE DEFAULT NULL;
121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;

Line 125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;

121: l_project_number pa_transaction_interface.project_number%TYPE DEFAULT NULL;
122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;

Line 126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;

122: l_task_number pa_transaction_interface.task_number%TYPE DEFAULT NULL;
123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;

Line 127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;

123: l_quantity pa_transaction_interface.quantity%TYPE DEFAULT NULL;
124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;

Line 128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;

124: l_raw_cost pa_transaction_interface.raw_cost%TYPE DEFAULT NULL;
125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;

Line 129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;

125: l_expenditure_id pa_transaction_interface.expenditure_id%TYPE DEFAULT NULL;
126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;

Line 130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;

126: l_attribute1 pa_transaction_interface.attribute1%TYPE DEFAULT NULL;
127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;

Line 131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;

127: l_attribute2 pa_transaction_interface.attribute2%TYPE DEFAULT NULL;
128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;

Line 132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;

128: l_attribute3 pa_transaction_interface.attribute3%TYPE DEFAULT NULL;
129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;

Line 133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;

129: l_attribute4 pa_transaction_interface.attribute4%TYPE DEFAULT NULL;
130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;

Line 134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;

130: l_attribute5 pa_transaction_interface.attribute5%TYPE DEFAULT NULL;
131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;

Line 135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;

131: l_attribute6 pa_transaction_interface.attribute6%TYPE DEFAULT NULL;
132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;
139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;

Line 136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;

132: l_attribute7 pa_transaction_interface.attribute7%TYPE DEFAULT NULL;
133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;
139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;
140:

Line 137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;

133: l_attribute8 pa_transaction_interface.attribute8%TYPE DEFAULT NULL;
134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;
139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;
140:
141: l_sub_loc VARCHAR2(10);

Line 138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;

134: l_attribute9 pa_transaction_interface.attribute9%TYPE DEFAULT NULL;
135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;
139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;
140:
141: l_sub_loc VARCHAR2(10);
142: l_organization_name VARCHAR2(240) DEFAULT NULL;

Line 139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;

135: l_attribute10 pa_transaction_interface.attribute10%TYPE DEFAULT NULL;
136: l_raw_cost_rate pa_transaction_interface.raw_cost_rate%TYPE DEFAULT NULL;
137: l_interface_id pa_transaction_interface.interface_id%TYPE DEFAULT NULL;
138: l_org_id pa_transaction_interface.org_id%TYPE DEFAULT NULL;
139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;
140:
141: l_sub_loc VARCHAR2(10);
142: l_organization_name VARCHAR2(240) DEFAULT NULL;
143: l_expenditure_type pa_transaction_interface.expenditure_type%TYPE DEFAULT NULL;

Line 143: l_expenditure_type pa_transaction_interface.expenditure_type%TYPE DEFAULT NULL;

139: l_gl_date pa_transaction_interface.gl_date%TYPE DEFAULT NULL;
140:
141: l_sub_loc VARCHAR2(10);
142: l_organization_name VARCHAR2(240) DEFAULT NULL;
143: l_expenditure_type pa_transaction_interface.expenditure_type%TYPE DEFAULT NULL;
144:
145: l_non_labor_resource_org_name VARCHAR2(240) DEFAULT NULL;
146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;
147:

Line 146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;

142: l_organization_name VARCHAR2(240) DEFAULT NULL;
143: l_expenditure_type pa_transaction_interface.expenditure_type%TYPE DEFAULT NULL;
144:
145: l_non_labor_resource_org_name VARCHAR2(240) DEFAULT NULL;
146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;
147:
148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;

Line 148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;

144:
145: l_non_labor_resource_org_name VARCHAR2(240) DEFAULT NULL;
146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;
147:
148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;

Line 149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;

145: l_non_labor_resource_org_name VARCHAR2(240) DEFAULT NULL;
146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;
147:
148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;

Line 150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;

146: l_non_labor_resource pa_transaction_interface.non_labor_resource%TYPE DEFAULT NULL;
147:
148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;

Line 151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;

147:
148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;

Line 152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;

148: l_cdl_system_reference1 pa_transaction_interface.cdl_system_reference1%TYPE DEFAULT NULL;
149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;

Line 153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;

149: l_cdl_system_reference2 pa_transaction_interface.cdl_system_reference2%TYPE DEFAULT NULL;
150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;

Line 154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;

150: l_cdl_system_reference3 pa_transaction_interface.cdl_system_reference3%TYPE DEFAULT NULL;
151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;

Line 155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;

151: l_expenditure_comment pa_transaction_interface.expenditure_comment%TYPE DEFAULT NULL;
152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:

Line 156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;

152: l_expenditure_ending_date pa_transaction_interface.expenditure_ending_date%TYPE DEFAULT NULL;
153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;

Line 157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;

153: l_expenditure_item_date pa_transaction_interface.expenditure_item_date%TYPE DEFAULT NULL;
154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;
161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;

Line 158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;

154: l_transaction_status_code pa_transaction_interface.transaction_status_code%TYPE DEFAULT NULL;
155: l_attribute_category pa_transaction_interface.attribute_category%TYPE DEFAULT NULL;
156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;
161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;
162: l_unmatched_negative_txn_flag pa_transaction_interface.unmatched_negative_txn_flag%TYPE DEFAULT NULL;

Line 160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;

156: l_expenditure_item_id pa_transaction_interface.expenditure_item_id%TYPE DEFAULT NULL;
157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;
161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;
162: l_unmatched_negative_txn_flag pa_transaction_interface.unmatched_negative_txn_flag%TYPE DEFAULT NULL;
163:
164: l_operating_unit_id NUMBER(15);

Line 161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;

157: l_dr_code_combination_id pa_transaction_interface.dr_code_combination_id%TYPE DEFAULT NULL;
158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;
161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;
162: l_unmatched_negative_txn_flag pa_transaction_interface.unmatched_negative_txn_flag%TYPE DEFAULT NULL;
163:
164: l_operating_unit_id NUMBER(15);
165: l_resource_id NUMBER;

Line 162: l_unmatched_negative_txn_flag pa_transaction_interface.unmatched_negative_txn_flag%TYPE DEFAULT NULL;

158: l_cr_code_combination_id pa_transaction_interface.cr_code_combination_id%TYPE DEFAULT NULL;
159:
160: l_transaction_rejection_code pa_transaction_interface.transaction_rejection_code%TYPE DEFAULT NULL;
161: l_orig_transaction_reference pa_transaction_interface.orig_transaction_reference%TYPE DEFAULT NULL;
162: l_unmatched_negative_txn_flag pa_transaction_interface.unmatched_negative_txn_flag%TYPE DEFAULT NULL;
163:
164: l_operating_unit_id NUMBER(15);
165: l_resource_id NUMBER;
166:

Line 452: INSERT INTO pa_transaction_interface_all

448: hr_utility.trace('l_cdl_system_reference2 :'||l_cdl_system_reference2);
449: hr_utility.trace('l_cdl_system_reference3 :'||l_cdl_system_reference3);
450: hr_utility.trace('l_gl_date :'||l_gl_date);
451: end if;
452: INSERT INTO pa_transaction_interface_all
453: ( TRANSACTION_SOURCE
454: ,BATCH_NAME
455: ,EXPENDITURE_ENDING_DATE
456: ,EMPLOYEE_NUMBER

Line 548: HXT_UTIL.DEBUG('after insert to pa_transaction_interface.'); --HXT115

544:
545: if g_debug then
546: hr_utility.set_location('HXT_PA_USER_EXITS.p_a_interface',140);
547: end if;
548: HXT_UTIL.DEBUG('after insert to pa_transaction_interface.'); --HXT115
549: RETURN 0;
550:
551: EXCEPTION
552: WHEN exp_type_nf THEN