APPS.PA_ADJUSTMENTS dependencies on DBMS_SQL

Line 5600: v_cursor_adj_id := dbms_sql.open_cursor ;

5596:
5597:
5598: /* *** Opens a cursor for processing ********************************************************* */
5599:
5600: v_cursor_adj_id := dbms_sql.open_cursor ;
5601:
5602: /* ******************************************************************************************* */
5603:
5604:

Line 6072: dbms_sql.parse( v_cursor_adj_id

6068:
6069: v_reserve_rec := ' FOR UPDATE OF ei.expenditure_item_id NOWAIT';
6070:
6071:
6072: dbms_sql.parse( v_cursor_adj_id
6073: , select_clause || from_clause || where_clause -- || v_reserve_rec - Commenting for bug 5501593
6074: , dbms_sql.v7);
6075:
6076:

Line 6074: , dbms_sql.v7);

6070:
6071:
6072: dbms_sql.parse( v_cursor_adj_id
6073: , select_clause || from_clause || where_clause -- || v_reserve_rec - Commenting for bug 5501593
6074: , dbms_sql.v7);
6075:
6076:
6077: if p_org_id is not null then
6078: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);

Line 6078: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);

6074: , dbms_sql.v7);
6075:
6076:
6077: if p_org_id is not null then
6078: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);
6079: end if;
6080:
6081: if x_project_id is not null then
6082: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);

Line 6082: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);

6078: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);
6079: end if;
6080:
6081: if x_project_id is not null then
6082: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);
6083: if x_task_id is not null then
6084: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
6085: end if;
6086: if p_award_id is not null then

Line 6084: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);

6080:
6081: if x_project_id is not null then
6082: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);
6083: if x_task_id is not null then
6084: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
6085: end if;
6086: if p_award_id is not null then
6087: dbms_sql.bind_variable(v_cursor_adj_id,':award_id', p_award_id);
6088: end if;

Line 6087: dbms_sql.bind_variable(v_cursor_adj_id,':award_id', p_award_id);

6083: if x_task_id is not null then
6084: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
6085: end if;
6086: if p_award_id is not null then
6087: dbms_sql.bind_variable(v_cursor_adj_id,':award_id', p_award_id);
6088: end if;
6089: end if;
6090:
6091: if x_expenditure_item_id is not null then

Line 6092: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_item_id', x_expenditure_item_id);

6088: end if;
6089: end if;
6090:
6091: if x_expenditure_item_id is not null then
6092: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_item_id', x_expenditure_item_id);
6093: end if;
6094:
6095: if x_inc_by_org_id is not null then
6096: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);

Line 6096: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);

6092: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_item_id', x_expenditure_item_id);
6093: end if;
6094:
6095: if x_inc_by_org_id is not null then
6096: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);
6097: end if ;
6098:
6099: if x_system_linkage is not null then
6100: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);

Line 6100: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);

6096: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);
6097: end if ;
6098:
6099: if x_system_linkage is not null then
6100: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);
6101: end if;
6102:
6103: if x_expenditure_type is not null then
6104: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);

Line 6104: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);

6100: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);
6101: end if;
6102:
6103: if x_expenditure_type is not null then
6104: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);
6105: end if;
6106:
6107: if x_ei_date_low is not null then
6108: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);

Line 6108: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);

6104: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);
6105: end if;
6106:
6107: if x_ei_date_low is not null then
6108: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);
6109: end if;
6110:
6111: if x_ei_date_high is not null then
6112: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);

Line 6112: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);

6108: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);
6109: end if;
6110:
6111: if x_ei_date_high is not null then
6112: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);
6113: end if;
6114:
6115: if x_expenditure_catg is not null then
6116: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);

Line 6116: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);

6112: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);
6113: end if;
6114:
6115: if x_expenditure_catg is not null then
6116: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);
6117: end if;
6118:
6119: if x_ex_end_date_low is not null then
6120: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);

Line 6120: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);

6116: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);
6117: end if;
6118:
6119: if x_ex_end_date_low is not null then
6120: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);
6121: end if;
6122:
6123: if x_ex_end_date_high is not null then
6124: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);

Line 6124: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);

6120: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);
6121: end if;
6122:
6123: if x_ex_end_date_high is not null then
6124: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);
6125: end if;
6126:
6127: if x_expenditure_group is not null then
6128: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);

Line 6128: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);

6124: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);
6125: end if;
6126:
6127: if x_expenditure_group is not null then
6128: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);
6129: end if;
6130:
6131: if x_transaction_source is not NULL then
6132: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);

Line 6132: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);

6128: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);
6129: end if;
6130:
6131: if x_transaction_source is not NULL then
6132: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);
6133: end if;
6134:
6135: if p_work_type_id is not null then
6136: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);

Line 6136: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);

6132: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);
6133: end if;
6134:
6135: if p_work_type_id is not null then
6136: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);
6137: end If;
6138:
6139: if x_cost_distributed_flag is not null then
6140: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);

Line 6140: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);

6136: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);
6137: end If;
6138:
6139: if x_cost_distributed_flag is not null then
6140: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);
6141: end if;
6142:
6143: if x_billable_flag is not null then
6144: dbms_sql.bind_variable(v_cursor_adj_id, ':billable_flag', x_billable_flag);

Line 6144: dbms_sql.bind_variable(v_cursor_adj_id, ':billable_flag', x_billable_flag);

6140: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);
6141: end if;
6142:
6143: if x_billable_flag is not null then
6144: dbms_sql.bind_variable(v_cursor_adj_id, ':billable_flag', x_billable_flag);
6145: end if;
6146:
6147: if x_hold_flag is not null then
6148: if x_hold_flag <> 'B' then

Line 6149: dbms_sql.bind_variable(v_cursor_adj_id, ':hold_flag', x_hold_flag);

6145: end if;
6146:
6147: if x_hold_flag is not null then
6148: if x_hold_flag <> 'B' then
6149: dbms_sql.bind_variable(v_cursor_adj_id, ':hold_flag', x_hold_flag);
6150: end if;
6151: end if;
6152:
6153: if x_revenue_distributed_flag is not null then

Line 6154: dbms_sql.bind_variable(v_cursor_adj_id, ':revenue_distributed_flag', x_revenue_distributed_flag);

6150: end if;
6151: end if;
6152:
6153: if x_revenue_distributed_flag is not null then
6154: dbms_sql.bind_variable(v_cursor_adj_id, ':revenue_distributed_flag', x_revenue_distributed_flag);
6155: end if;
6156:
6157: if X_inc_by_person_id is not null then
6158: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);

Line 6158: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);

6154: dbms_sql.bind_variable(v_cursor_adj_id, ':revenue_distributed_flag', x_revenue_distributed_flag);
6155: end if;
6156:
6157: if X_inc_by_person_id is not null then
6158: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);
6159: end if ;
6160:
6161: if X_job_id is not null then
6162: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);

Line 6162: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);

6158: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);
6159: end if ;
6160:
6161: if X_job_id is not null then
6162: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);
6163: end if;
6164:
6165: if p_assignment_id is not null then
6166: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);

Line 6166: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);

6162: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);
6163: end if;
6164:
6165: if p_assignment_id is not null then
6166: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);
6167: end if;
6168:
6169: if X_nl_resource_org_id is not null then
6170: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);

Line 6170: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);

6166: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);
6167: end if;
6168:
6169: if X_nl_resource_org_id is not null then
6170: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);
6171: end if;
6172:
6173: if p_wip_resource_id is not null then
6174: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);

Line 6174: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);

6170: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);
6171: end if;
6172:
6173: if p_wip_resource_id is not null then
6174: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);
6175: end if;
6176:
6177: if p_inventory_item_id is not null then
6178: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);

Line 6178: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);

6174: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);
6175: end if;
6176:
6177: if p_inventory_item_id is not null then
6178: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);
6179: end if;
6180:
6181: if x_vendor_id is not null then
6182: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);

Line 6182: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);

6178: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);
6179: end if;
6180:
6181: if x_vendor_id is not null then
6182: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);
6183: end if;
6184:
6185: IF p_invoice_id IS NOT NULL THEN
6186: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);

Line 6186: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);

6182: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);
6183: end if;
6184:
6185: IF p_invoice_id IS NOT NULL THEN
6186: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);
6187: IF p_invoice_line_number IS NOT NULL THEN
6188: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_line_number', p_invoice_line_number);
6189: END IF;
6190: END IF;

Line 6188: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_line_number', p_invoice_line_number);

6184:
6185: IF p_invoice_id IS NOT NULL THEN
6186: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);
6187: IF p_invoice_line_number IS NOT NULL THEN
6188: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_line_number', p_invoice_line_number);
6189: END IF;
6190: END IF;
6191:
6192: IF p_receipt_number IS NOT NULL THEN

Line 6193: dbms_sql.bind_variable(v_cursor_adj_id, ':receipt_number', p_receipt_number);

6189: END IF;
6190: END IF;
6191:
6192: IF p_receipt_number IS NOT NULL THEN
6193: dbms_sql.bind_variable(v_cursor_adj_id, ':receipt_number', p_receipt_number);
6194: END IF;
6195:
6196: IF p_check_id IS NOT NULL THEN
6197: dbms_sql.bind_variable(v_cursor_adj_id, ':check_id', p_check_id);

Line 6197: dbms_sql.bind_variable(v_cursor_adj_id, ':check_id', p_check_id);

6193: dbms_sql.bind_variable(v_cursor_adj_id, ':receipt_number', p_receipt_number);
6194: END IF;
6195:
6196: IF p_check_id IS NOT NULL THEN
6197: dbms_sql.bind_variable(v_cursor_adj_id, ':check_id', p_check_id);
6198: END IF;
6199:
6200: if X_cc_code_to_be_determined <> 'N'
6201: or X_cc_code_not_crosscharged <> 'XX'

Line 6205: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);

6201: or X_cc_code_not_crosscharged <> 'XX'
6202: or X_cc_code_intra_ou <> 'XX'
6203: or X_cc_code_inter_ou <> 'XX'
6204: or X_cc_code_intercompany <> 'XX' then
6205: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6206: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6207: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6208: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6209: end if;

Line 6206: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);

6202: or X_cc_code_intra_ou <> 'XX'
6203: or X_cc_code_inter_ou <> 'XX'
6204: or X_cc_code_intercompany <> 'XX' then
6205: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6206: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6207: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6208: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6209: end if;
6210:

Line 6207: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);

6203: or X_cc_code_inter_ou <> 'XX'
6204: or X_cc_code_intercompany <> 'XX' then
6205: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6206: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6207: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6208: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6209: end if;
6210:
6211: if X_cc_type_no_processing <> 'Z'

Line 6208: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);

6204: or X_cc_code_intercompany <> 'XX' then
6205: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6206: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6207: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6208: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6209: end if;
6210:
6211: if X_cc_type_no_processing <> 'Z'
6212: or X_cc_type_b_and_l <> 'Z'

Line 6214: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);

6210:
6211: if X_cc_type_no_processing <> 'Z'
6212: or X_cc_type_b_and_l <> 'Z'
6213: or X_cc_type_ic_billing <> 'Z' then
6214: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6215: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6216: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6217: end if;
6218:

Line 6215: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);

6211: if X_cc_type_no_processing <> 'Z'
6212: or X_cc_type_b_and_l <> 'Z'
6213: or X_cc_type_ic_billing <> 'Z' then
6214: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6215: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6216: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6217: end if;
6218:
6219: if X_cc_bl_distributed_code is not null then

Line 6216: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);

6212: or X_cc_type_b_and_l <> 'Z'
6213: or X_cc_type_ic_billing <> 'Z' then
6214: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6215: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6216: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6217: end if;
6218:
6219: if X_cc_bl_distributed_code is not null then
6220: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);

Line 6220: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);

6216: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6217: end if;
6218:
6219: if X_cc_bl_distributed_code is not null then
6220: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);
6221: end if;
6222:
6223: if X_cc_ic_processed_code is not null then
6224: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);

Line 6224: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);

6220: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);
6221: end if;
6222:
6223: if X_cc_ic_processed_code is not null then
6224: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);
6225: end if;
6226:
6227: if X_cc_prvdr_organization_id is not null then
6228: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);

Line 6228: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);

6224: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);
6225: end if;
6226:
6227: if X_cc_prvdr_organization_id is not null then
6228: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);
6229: end if;
6230:
6231: if X_cc_prvdr_ou is not null then
6232: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);

Line 6232: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);

6228: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);
6229: end if;
6230:
6231: if X_cc_prvdr_ou is not null then
6232: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);
6233: end if;
6234:
6235: if p_start_gl_date is not null then
6236: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);

Line 6236: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);

6232: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);
6233: end if;
6234:
6235: if p_start_gl_date is not null then
6236: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);
6237: end if;
6238:
6239: if p_end_gl_date is not null then
6240: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);

Line 6240: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);

6236: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);
6237: end if;
6238:
6239: if p_end_gl_date is not null then
6240: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);
6241: end if ;
6242:
6243: if p_start_pa_date is not null then
6244: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);

Line 6244: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);

6240: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);
6241: end if ;
6242:
6243: if p_start_pa_date is not null then
6244: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);
6245: end if;
6246:
6247: if p_end_pa_date is not null then
6248: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);

Line 6248: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);

6244: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);
6245: end if;
6246:
6247: if p_end_pa_date is not null then
6248: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);
6249: end if ;
6250:
6251: if X_cc_recvr_organization_id is not null then
6252: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);

Line 6252: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);

6248: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);
6249: end if ;
6250:
6251: if X_cc_recvr_organization_id is not null then
6252: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);
6253: end if;
6254:
6255: if X_cc_recvr_ou is not null then
6256: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);

Line 6256: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);

6252: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);
6253: end if;
6254:
6255: if X_cc_recvr_ou is not null then
6256: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);
6257: end if;
6258:
6259: if p_recvr_start_gl_date is not null then
6260: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);

Line 6260: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);

6256: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);
6257: end if;
6258:
6259: if p_recvr_start_gl_date is not null then
6260: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);
6261: end if;
6262:
6263: if p_recvr_end_gl_date is not null then
6264: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);

Line 6264: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);

6260: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);
6261: end if;
6262:
6263: if p_recvr_end_gl_date is not null then
6264: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);
6265: end if ;
6266:
6267: if p_recvr_start_pa_date is not null then
6268: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);

Line 6268: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);

6264: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);
6265: end if ;
6266:
6267: if p_recvr_start_pa_date is not null then
6268: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);
6269: end if;
6270:
6271: if p_recvr_end_pa_date is not null then
6272: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);

Line 6272: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);

6268: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);
6269: end if;
6270:
6271: if p_recvr_end_pa_date is not null then
6272: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);
6273: end if ;
6274:
6275: if x_capitalizable_flag is not null then
6276: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);

Line 6276: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);

6272: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);
6273: end if ;
6274:
6275: if x_capitalizable_flag is not null then
6276: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);
6277: end if;
6278:
6279: if x_grouped_cip_flag is not null then
6280: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);

Line 6280: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);

6276: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);
6277: end if;
6278:
6279: if x_grouped_cip_flag is not null then
6280: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);
6281: end if;
6282:
6283: if p_grouped_rwip_flag is not null then
6284: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_rwip_flag', p_grouped_rwip_flag);

Line 6284: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_rwip_flag', p_grouped_rwip_flag);

6280: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);
6281: end if;
6282:
6283: if p_grouped_rwip_flag is not null then
6284: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_rwip_flag', p_grouped_rwip_flag);
6285: end if;
6286:
6287: if p_capital_event_number is not null then
6288: if p_capital_event_number <> -1 then

Line 6289: dbms_sql.bind_variable(v_cursor_adj_id, ':capital_event_number', p_capital_event_number);

6285: end if;
6286:
6287: if p_capital_event_number is not null then
6288: if p_capital_event_number <> -1 then
6289: dbms_sql.bind_variable(v_cursor_adj_id, ':capital_event_number', p_capital_event_number);
6290: end if;
6291: end if;
6292:
6293: /* Start: Added for bug 16446988 */

Line 6295: dbms_sql.bind_variable(v_cursor_adj_id, ':cbs_element_id', p_cbs_element_id);

6291: end if;
6292:
6293: /* Start: Added for bug 16446988 */
6294: if p_cbs_element_id is not null then
6295: dbms_sql.bind_variable(v_cursor_adj_id, ':cbs_element_id', p_cbs_element_id);
6296: end if;
6297: /* End: Added for bug 16446988 */
6298:
6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);

Line 6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);

6295: dbms_sql.bind_variable(v_cursor_adj_id, ':cbs_element_id', p_cbs_element_id);
6296: end if;
6297: /* End: Added for bug 16446988 */
6298:
6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);

Line 6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);

6296: end if;
6297: /* End: Added for bug 16446988 */
6298:
6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);

Line 6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);

6297: /* End: Added for bug 16446988 */
6298:
6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

Line 6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);

6298:
6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);

Line 6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);

6299: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);

Line 6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);

6300: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);

Line 6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

6301: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);

Line 6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);

6302: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);

Line 6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);

6303: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);

Line 6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);

6304: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);

Line 6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);

6305: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);

Line 6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);

6306: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);

Line 6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);

6307: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);

Line 6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);

6308: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);

Line 6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);

6309: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);

Line 6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);

6310: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

Line 6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);

6311: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);

Line 6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);

6312: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);

Line 6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);

6313: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);

Line 6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

6314: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);

Line 6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);

6315: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);

Line 6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);

6316: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);

Line 6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);

6317: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);

Line 6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);

6318: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);

Line 6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);

6319: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);

Line 6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);

6320: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);

Line 6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);

6321: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);

Line 6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);

6322: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);

Line 6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);

6323: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);

Line 6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);

6324: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration

Line 6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);

6325: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);

Line 6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);

6326: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);

Line 6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);

6327: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6328: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);
6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);

Line 6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);

6329: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);
6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);
6336: dbms_sql.define_column(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6337:

Line 6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);

6330: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);
6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);
6336: dbms_sql.define_column(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6337:
6338:

Line 6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);

6331: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);
6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);
6336: dbms_sql.define_column(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6337:
6338:
6339:

Line 6336: dbms_sql.define_column(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146

6332: --rkuttiya added for 12.2 Projects Payroll Integration
6333: dbms_sql.define_column(v_cursor_adj_id,34,l_prev_costing_method, 30);
6334: dbms_sql.define_column(v_cursor_adj_id,35,l_prev_rate_source_code, 30);
6335: dbms_sql.define_column(v_cursor_adj_id,36,l_prev_accrual_flag, 30);
6336: dbms_sql.define_column(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6337:
6338:
6339:
6340:

Line 6344: v_open_cursor := dbms_sql.execute(v_cursor_adj_id);

6340:
6341:
6342:
6343: IF ( X_module IN ( 'PAXPRRPE','PAXPREPR','PAXBAUPD','PATXMAS') ) THEN
6344: v_open_cursor := dbms_sql.execute(v_cursor_adj_id);
6345: LOOP
6346: /* Fetch the rows into the buffer ************************* */
6347: IF P_DEBUG_MODE THEN
6348: print_message('get_denom_curr_code: ' || 'Fetch the rows into the buffer');

Line 6351: If dbms_sql.fetch_rows(v_cursor_adj_id) = 0 then

6347: IF P_DEBUG_MODE THEN
6348: print_message('get_denom_curr_code: ' || 'Fetch the rows into the buffer');
6349: END IF;
6350:
6351: If dbms_sql.fetch_rows(v_cursor_adj_id) = 0 then
6352: --Exit the loop once all the records are fetched
6353:
6354: exit ;
6355: end if ;

Line 6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);

6354: exit ;
6355: end if ;
6356:
6357: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);

Line 6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);

6355: end if ;
6356:
6357: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);

Line 6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);

6356:
6357: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

Line 6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);

6357: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);

Line 6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);

6358: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);

Line 6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);

6359: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);

Line 6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

6360: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);

Line 6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);

6361: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);

Line 6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);

6362: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);

Line 6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);

6363: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);

Line 6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);

6364: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);

Line 6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);

6365: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);

Line 6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);

6366: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);

Line 6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);

6367: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);

Line 6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);

6368: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);

Line 6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);

6369: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

Line 6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);

6370: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);

Line 6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);

6371: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);

Line 6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);

6372: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);

Line 6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

6373: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);

Line 6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);

6374: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);

Line 6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);

6375: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);

Line 6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);

6376: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);

Line 6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);

6377: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);

Line 6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);

6378: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);

Line 6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);

6379: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);

Line 6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);

6380: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);

Line 6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);

6381: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);

Line 6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);

6382: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);

Line 6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);

6383: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration

Line 6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);

6384: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);

Line 6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);

6385: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);

Line 6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);

6386: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6387: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);
6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);

Line 6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);

6388: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);
6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);
6395: dbms_sql.column_value(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6396:

Line 6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);

6389: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);
6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);
6395: dbms_sql.column_value(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6396:
6397: /* Bug 5441891 - Start */

Line 6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);

6390: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);
6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);
6395: dbms_sql.column_value(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6396:
6397: /* Bug 5441891 - Start */
6398: IF l_project_id <> l_project_id_cache THEN

Line 6395: dbms_sql.column_value(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146

6391: --rkuttiya added for 12.2 Projects Payroll Integration
6392: dbms_sql.column_value(v_cursor_adj_id,34,l_prev_costing_method);
6393: dbms_sql.column_value(v_cursor_adj_id,35,l_prev_rate_source_code);
6394: dbms_sql.column_value(v_cursor_adj_id,36,l_prev_accrual_flag);
6395: dbms_sql.column_value(v_cursor_adj_id,37,l_cbs_element_id); -- Added for CBS Enhancement Bug 16220146
6396:
6397: /* Bug 5441891 - Start */
6398: IF l_project_id <> l_project_id_cache THEN
6399: SELECT pt.project_type_class_code

Line 7268: dbms_sql.close_cursor(v_cursor_adj_id) ;

7264: -- procedure was called multiple times. Customer - Oakridge
7265: IF P_DEBUG_MODE THEN
7266: print_message('get_denom_curr_code: ' || 'close the cursor ');
7267: END IF;
7268: dbms_sql.close_cursor(v_cursor_adj_id) ;
7269:
7270: IF i >= 1 then
7271: IF X_adj_action <> 'INDIRECT COST RECALC' then
7272: IF P_DEBUG_MODE THEN