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.PA_ADJUSTMENTS dependencies on DBMS_SQL

Line 5475: v_cursor_adj_id := dbms_sql.open_cursor ;

5471:
5472:
5473: /* *** Opens a cursor for processing ********************************************************* */
5474:
5475: v_cursor_adj_id := dbms_sql.open_cursor ;
5476:
5477: /* ******************************************************************************************* */
5478:
5479:

Line 5923: dbms_sql.parse( v_cursor_adj_id

5919:
5920: v_reserve_rec := ' FOR UPDATE OF ei.expenditure_item_id NOWAIT';
5921:
5922:
5923: dbms_sql.parse( v_cursor_adj_id
5924: , select_clause || from_clause || where_clause -- || v_reserve_rec - Commenting for bug 5501593
5925: , dbms_sql.v7);
5926:
5927:

Line 5925: , dbms_sql.v7);

5921:
5922:
5923: dbms_sql.parse( v_cursor_adj_id
5924: , select_clause || from_clause || where_clause -- || v_reserve_rec - Commenting for bug 5501593
5925: , dbms_sql.v7);
5926:
5927:
5928: if p_org_id is not null then
5929: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);

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

5925: , dbms_sql.v7);
5926:
5927:
5928: if p_org_id is not null then
5929: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);
5930: end if;
5931:
5932: if x_project_id is not null then
5933: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);

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

5929: dbms_sql.bind_variable(v_cursor_adj_id, ':org_id', p_org_id);
5930: end if;
5931:
5932: if x_project_id is not null then
5933: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);
5934: if x_task_id is not null then
5935: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
5936: end if;
5937: if p_award_id is not null then

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

5931:
5932: if x_project_id is not null then
5933: dbms_sql.bind_variable(v_cursor_adj_id, ':project_id', x_project_id);
5934: if x_task_id is not null then
5935: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
5936: end if;
5937: if p_award_id is not null then
5938: dbms_sql.bind_variable(v_cursor_adj_id,':award_id', p_award_id);
5939: end if;

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

5934: if x_task_id is not null then
5935: dbms_sql.bind_variable(v_cursor_adj_id, ':task_id', x_task_id);
5936: end if;
5937: if p_award_id is not null then
5938: dbms_sql.bind_variable(v_cursor_adj_id,':award_id', p_award_id);
5939: end if;
5940: end if;
5941:
5942: if x_expenditure_item_id is not null then

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

5939: end if;
5940: end if;
5941:
5942: if x_expenditure_item_id is not null then
5943: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_item_id', x_expenditure_item_id);
5944: end if;
5945:
5946: if x_inc_by_org_id is not null then
5947: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);

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

5943: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_item_id', x_expenditure_item_id);
5944: end if;
5945:
5946: if x_inc_by_org_id is not null then
5947: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);
5948: end if ;
5949:
5950: if x_system_linkage is not null then
5951: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);

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

5947: dbms_sql.bind_variable(v_cursor_adj_id, ':inc_by_org_id', x_inc_by_org_id);
5948: end if ;
5949:
5950: if x_system_linkage is not null then
5951: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);
5952: end if;
5953:
5954: if x_expenditure_type is not null then
5955: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);

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

5951: dbms_sql.bind_variable(v_cursor_adj_id, ':system_linkage', x_system_linkage);
5952: end if;
5953:
5954: if x_expenditure_type is not null then
5955: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);
5956: end if;
5957:
5958: if x_ei_date_low is not null then
5959: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);

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

5955: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_type', x_expenditure_type);
5956: end if;
5957:
5958: if x_ei_date_low is not null then
5959: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);
5960: end if;
5961:
5962: if x_ei_date_high is not null then
5963: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);

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

5959: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_low', x_ei_date_low);
5960: end if;
5961:
5962: if x_ei_date_high is not null then
5963: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);
5964: end if;
5965:
5966: if x_expenditure_catg is not null then
5967: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);

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

5963: dbms_sql.bind_variable(v_cursor_adj_id, ':ei_date_high', x_ei_date_high);
5964: end if;
5965:
5966: if x_expenditure_catg is not null then
5967: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);
5968: end if;
5969:
5970: if x_ex_end_date_low is not null then
5971: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);

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

5967: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_catg', x_expenditure_catg);
5968: end if;
5969:
5970: if x_ex_end_date_low is not null then
5971: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);
5972: end if;
5973:
5974: if x_ex_end_date_high is not null then
5975: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);

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

5971: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_low', x_ex_end_date_low);
5972: end if;
5973:
5974: if x_ex_end_date_high is not null then
5975: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);
5976: end if;
5977:
5978: if x_expenditure_group is not null then
5979: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);

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

5975: dbms_sql.bind_variable(v_cursor_adj_id, ':ex_end_date_high', x_ex_end_date_high);
5976: end if;
5977:
5978: if x_expenditure_group is not null then
5979: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);
5980: end if;
5981:
5982: if x_transaction_source is not NULL then
5983: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);

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

5979: dbms_sql.bind_variable(v_cursor_adj_id, ':expenditure_group', x_expenditure_group);
5980: end if;
5981:
5982: if x_transaction_source is not NULL then
5983: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);
5984: end if;
5985:
5986: if p_work_type_id is not null then
5987: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);

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

5983: dbms_sql.bind_variable(v_cursor_adj_id, ':transaction_source', x_transaction_source);
5984: end if;
5985:
5986: if p_work_type_id is not null then
5987: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);
5988: end If;
5989:
5990: if x_cost_distributed_flag is not null then
5991: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);

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

5987: dbms_sql.bind_variable(v_cursor_adj_id, ':work_type_id', p_work_type_id);
5988: end If;
5989:
5990: if x_cost_distributed_flag is not null then
5991: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);
5992: end if;
5993:
5994: if x_billable_flag is not null then
5995: dbms_sql.bind_variable(v_cursor_adj_id, ':billable_flag', x_billable_flag);

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

5991: dbms_sql.bind_variable(v_cursor_adj_id, ':cost_distributed_flag', x_cost_distributed_flag);
5992: end if;
5993:
5994: if x_billable_flag is not null then
5995: dbms_sql.bind_variable(v_cursor_adj_id, ':billable_flag', x_billable_flag);
5996: end if;
5997:
5998: if x_hold_flag is not null then
5999: if x_hold_flag <> 'B' then

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

5996: end if;
5997:
5998: if x_hold_flag is not null then
5999: if x_hold_flag <> 'B' then
6000: dbms_sql.bind_variable(v_cursor_adj_id, ':hold_flag', x_hold_flag);
6001: end if;
6002: end if;
6003:
6004: if x_revenue_distributed_flag is not null then

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

6001: end if;
6002: end if;
6003:
6004: if x_revenue_distributed_flag is not null then
6005: dbms_sql.bind_variable(v_cursor_adj_id, ':revenue_distributed_flag', x_revenue_distributed_flag);
6006: end if;
6007:
6008: if X_inc_by_person_id is not null then
6009: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);

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

6005: dbms_sql.bind_variable(v_cursor_adj_id, ':revenue_distributed_flag', x_revenue_distributed_flag);
6006: end if;
6007:
6008: if X_inc_by_person_id is not null then
6009: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);
6010: end if ;
6011:
6012: if X_job_id is not null then
6013: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);

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

6009: dbms_sql.bind_variable(v_cursor_adj_id, ':incurred_by_person_id', X_inc_by_person_id);
6010: end if ;
6011:
6012: if X_job_id is not null then
6013: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);
6014: end if;
6015:
6016: if p_assignment_id is not null then
6017: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);

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

6013: dbms_sql.bind_variable(v_cursor_adj_id, ':job_id', X_job_id);
6014: end if;
6015:
6016: if p_assignment_id is not null then
6017: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);
6018: end if;
6019:
6020: if X_nl_resource_org_id is not null then
6021: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);

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

6017: dbms_sql.bind_variable(v_cursor_adj_id, ':assignment_id', p_assignment_id);
6018: end if;
6019:
6020: if X_nl_resource_org_id is not null then
6021: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);
6022: end if;
6023:
6024: if p_wip_resource_id is not null then
6025: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);

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

6021: dbms_sql.bind_variable(v_cursor_adj_id, ':nl_resource_org_id', X_nl_resource_org_id);
6022: end if;
6023:
6024: if p_wip_resource_id is not null then
6025: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);
6026: end if;
6027:
6028: if p_inventory_item_id is not null then
6029: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);

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

6025: dbms_sql.bind_variable(v_cursor_adj_id, ':wip_resource_id', p_wip_resource_id);
6026: end if;
6027:
6028: if p_inventory_item_id is not null then
6029: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);
6030: end if;
6031:
6032: if x_vendor_id is not null then
6033: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);

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

6029: dbms_sql.bind_variable(v_cursor_adj_id, ':inventory_item_id', p_inventory_item_id);
6030: end if;
6031:
6032: if x_vendor_id is not null then
6033: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);
6034: end if;
6035:
6036: IF p_invoice_id IS NOT NULL THEN
6037: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);

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

6033: dbms_sql.bind_variable(v_cursor_adj_id, ':vendor_id', x_vendor_id);
6034: end if;
6035:
6036: IF p_invoice_id IS NOT NULL THEN
6037: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);
6038: IF p_invoice_line_number IS NOT NULL THEN
6039: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_line_number', p_invoice_line_number);
6040: END IF;
6041: END IF;

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

6035:
6036: IF p_invoice_id IS NOT NULL THEN
6037: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_id', p_invoice_id);
6038: IF p_invoice_line_number IS NOT NULL THEN
6039: dbms_sql.bind_variable(v_cursor_adj_id, ':invoice_line_number', p_invoice_line_number);
6040: END IF;
6041: END IF;
6042:
6043: IF p_receipt_number IS NOT NULL THEN

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

6040: END IF;
6041: END IF;
6042:
6043: IF p_receipt_number IS NOT NULL THEN
6044: dbms_sql.bind_variable(v_cursor_adj_id, ':receipt_number', p_receipt_number);
6045: END IF;
6046:
6047: IF p_check_id IS NOT NULL THEN
6048: dbms_sql.bind_variable(v_cursor_adj_id, ':check_id', p_check_id);

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

6044: dbms_sql.bind_variable(v_cursor_adj_id, ':receipt_number', p_receipt_number);
6045: END IF;
6046:
6047: IF p_check_id IS NOT NULL THEN
6048: dbms_sql.bind_variable(v_cursor_adj_id, ':check_id', p_check_id);
6049: END IF;
6050:
6051: if X_cc_code_to_be_determined <> 'N'
6052: or X_cc_code_not_crosscharged <> 'XX'

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

6052: or X_cc_code_not_crosscharged <> 'XX'
6053: or X_cc_code_intra_ou <> 'XX'
6054: or X_cc_code_inter_ou <> 'XX'
6055: or X_cc_code_intercompany <> 'XX' then
6056: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6057: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6058: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6059: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6060: end if;

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

6053: or X_cc_code_intra_ou <> 'XX'
6054: or X_cc_code_inter_ou <> 'XX'
6055: or X_cc_code_intercompany <> 'XX' then
6056: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6057: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6058: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6059: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6060: end if;
6061:

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

6054: or X_cc_code_inter_ou <> 'XX'
6055: or X_cc_code_intercompany <> 'XX' then
6056: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6057: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6058: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6059: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6060: end if;
6061:
6062: if X_cc_type_no_processing <> 'Z'

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

6055: or X_cc_code_intercompany <> 'XX' then
6056: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_not_crosscharged', X_cc_code_not_crosscharged);
6057: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intra_ou', X_cc_code_intra_ou);
6058: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_inter_ou', X_cc_code_inter_ou);
6059: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_code_intercompany', X_cc_code_intercompany);
6060: end if;
6061:
6062: if X_cc_type_no_processing <> 'Z'
6063: or X_cc_type_b_and_l <> 'Z'

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

6061:
6062: if X_cc_type_no_processing <> 'Z'
6063: or X_cc_type_b_and_l <> 'Z'
6064: or X_cc_type_ic_billing <> 'Z' then
6065: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6066: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6067: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6068: end if;
6069:

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

6062: if X_cc_type_no_processing <> 'Z'
6063: or X_cc_type_b_and_l <> 'Z'
6064: or X_cc_type_ic_billing <> 'Z' then
6065: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6066: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6067: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6068: end if;
6069:
6070: if X_cc_bl_distributed_code is not null then

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

6063: or X_cc_type_b_and_l <> 'Z'
6064: or X_cc_type_ic_billing <> 'Z' then
6065: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_no_processing', X_cc_type_no_processing);
6066: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_b_and_l', X_cc_type_b_and_l);
6067: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6068: end if;
6069:
6070: if X_cc_bl_distributed_code is not null then
6071: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);

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

6067: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_type_ic_billing', X_cc_type_ic_billing);
6068: end if;
6069:
6070: if X_cc_bl_distributed_code is not null then
6071: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);
6072: end if;
6073:
6074: if X_cc_ic_processed_code is not null then
6075: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);

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

6071: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_bl_distributed_code', X_cc_bl_distributed_code);
6072: end if;
6073:
6074: if X_cc_ic_processed_code is not null then
6075: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);
6076: end if;
6077:
6078: if X_cc_prvdr_organization_id is not null then
6079: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);

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

6075: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_ic_processed_code', X_cc_ic_processed_code);
6076: end if;
6077:
6078: if X_cc_prvdr_organization_id is not null then
6079: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);
6080: end if;
6081:
6082: if X_cc_prvdr_ou is not null then
6083: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);

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

6079: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_organization_id', X_cc_prvdr_organization_id);
6080: end if;
6081:
6082: if X_cc_prvdr_ou is not null then
6083: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);
6084: end if;
6085:
6086: if p_start_gl_date is not null then
6087: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);

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

6083: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_prvdr_ou', X_cc_prvdr_ou);
6084: end if;
6085:
6086: if p_start_gl_date is not null then
6087: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);
6088: end if;
6089:
6090: if p_end_gl_date is not null then
6091: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);

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

6087: dbms_sql.bind_variable(v_cursor_adj_id, ':start_gl_date', p_start_gl_date);
6088: end if;
6089:
6090: if p_end_gl_date is not null then
6091: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);
6092: end if ;
6093:
6094: if p_start_pa_date is not null then
6095: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);

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

6091: dbms_sql.bind_variable(v_cursor_adj_id, ':end_gl_date', p_end_gl_date);
6092: end if ;
6093:
6094: if p_start_pa_date is not null then
6095: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);
6096: end if;
6097:
6098: if p_end_pa_date is not null then
6099: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);

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

6095: dbms_sql.bind_variable(v_cursor_adj_id, ':start_pa_date', p_start_pa_date);
6096: end if;
6097:
6098: if p_end_pa_date is not null then
6099: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);
6100: end if ;
6101:
6102: if X_cc_recvr_organization_id is not null then
6103: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);

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

6099: dbms_sql.bind_variable(v_cursor_adj_id, ':end_pa_date', p_end_pa_date);
6100: end if ;
6101:
6102: if X_cc_recvr_organization_id is not null then
6103: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);
6104: end if;
6105:
6106: if X_cc_recvr_ou is not null then
6107: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);

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

6103: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_organization_id', X_cc_recvr_organization_id);
6104: end if;
6105:
6106: if X_cc_recvr_ou is not null then
6107: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);
6108: end if;
6109:
6110: if p_recvr_start_gl_date is not null then
6111: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);

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

6107: dbms_sql.bind_variable(v_cursor_adj_id, ':cc_recvr_ou', X_cc_recvr_ou);
6108: end if;
6109:
6110: if p_recvr_start_gl_date is not null then
6111: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);
6112: end if;
6113:
6114: if p_recvr_end_gl_date is not null then
6115: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);

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

6111: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_gl_date', p_recvr_start_gl_date);
6112: end if;
6113:
6114: if p_recvr_end_gl_date is not null then
6115: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);
6116: end if ;
6117:
6118: if p_recvr_start_pa_date is not null then
6119: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);

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

6115: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_gl_date', p_recvr_end_gl_date);
6116: end if ;
6117:
6118: if p_recvr_start_pa_date is not null then
6119: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);
6120: end if;
6121:
6122: if p_recvr_end_pa_date is not null then
6123: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);

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

6119: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_start_pa_date', p_recvr_start_pa_date);
6120: end if;
6121:
6122: if p_recvr_end_pa_date is not null then
6123: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);
6124: end if ;
6125:
6126: if x_capitalizable_flag is not null then
6127: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);

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

6123: dbms_sql.bind_variable(v_cursor_adj_id, ':recvr_end_pa_date', p_recvr_end_pa_date);
6124: end if ;
6125:
6126: if x_capitalizable_flag is not null then
6127: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);
6128: end if;
6129:
6130: if x_grouped_cip_flag is not null then
6131: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);

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

6127: dbms_sql.bind_variable(v_cursor_adj_id, ':capitalizable_flag', x_capitalizable_flag);
6128: end if;
6129:
6130: if x_grouped_cip_flag is not null then
6131: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);
6132: end if;
6133:
6134: if p_grouped_rwip_flag is not null then
6135: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_rwip_flag', p_grouped_rwip_flag);

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

6131: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_cip_flag', x_grouped_cip_flag);
6132: end if;
6133:
6134: if p_grouped_rwip_flag is not null then
6135: dbms_sql.bind_variable(v_cursor_adj_id, ':grouped_rwip_flag', p_grouped_rwip_flag);
6136: end if;
6137:
6138: if p_capital_event_number is not null then
6139: if p_capital_event_number <> -1 then

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

6136: end if;
6137:
6138: if p_capital_event_number is not null then
6139: if p_capital_event_number <> -1 then
6140: dbms_sql.bind_variable(v_cursor_adj_id, ':capital_event_number', p_capital_event_number);
6141: end if;
6142: end if;
6143:
6144:

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

6141: end if;
6142: end if;
6143:
6144:
6145: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);

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

6142: end if;
6143:
6144:
6145: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);

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

6143:
6144:
6145: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

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

6144:
6145: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);

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

6145: dbms_sql.define_column(v_cursor_adj_id, 1, v_expenditure_item_id);
6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);

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

6146: dbms_sql.define_column(v_cursor_adj_id, 2, v_exp_org_id);
6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);

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

6147: dbms_sql.define_column(v_cursor_adj_id, 3, l_project_id);
6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);

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

6148: dbms_sql.define_column(v_cursor_adj_id, 4, l_net_zero_adjustment_flag, 1);
6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);

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

6149: dbms_sql.define_column(v_cursor_adj_id, 5, l_converted_flag, 1);
6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);

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

6150: dbms_sql.define_column(v_cursor_adj_id, 6, l_expenditure_status_code, 30);
6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);

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

6151: dbms_sql.define_column(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);

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

6152: dbms_sql.define_column(v_cursor_adj_id, 8, l_document_header_id);
6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);

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

6153: dbms_sql.define_column(v_cursor_adj_id, 9, l_transaction_source, 30);
6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);

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

6154: dbms_sql.define_column(v_cursor_adj_id, 10, l_document_type, 30);
6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);

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

6155: dbms_sql.define_column(v_cursor_adj_id, 11, l_document_distribution_type, 30);
6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);

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

6156: dbms_sql.define_column(v_cursor_adj_id, 12, l_document_payment_id);
6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

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

6157: dbms_sql.define_column(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);

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

6158: dbms_sql.define_column(v_cursor_adj_id, 14, v_system_linkage, 30);
6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);

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

6159: dbms_sql.define_column(v_cursor_adj_id, 15, l_acct_currency_code, 15);
6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);

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

6160: dbms_sql.define_column(v_cursor_adj_id, 16, v_denom_currency_code, 15);
6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);

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

6161: dbms_sql.define_column(v_cursor_adj_id, 17, v_denom_tp_currency_code, 15);
6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);

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

6162: dbms_sql.define_column(v_cursor_adj_id, 18, l_projfunc_currency_code, 15);
6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);

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

6163: dbms_sql.define_column(v_cursor_adj_id, 19, v_cc_code, 1);
6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);

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

6164: dbms_sql.define_column(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);

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

6165: dbms_sql.define_column(v_cursor_adj_id, 21, l_orig_transaction_reference, 30);
6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);

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

6166: dbms_sql.define_column(v_cursor_adj_id, 22, v_exp_item_date);
6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);

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

6167: dbms_sql.define_column(v_cursor_adj_id, 23, l_billable_flag, 1);
6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);

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

6168: dbms_sql.define_column(v_cursor_adj_id, 24, v_task_id);
6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);

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

6169: dbms_sql.define_column(v_cursor_adj_id, 25, v_exp_type, 30);
6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6177: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);

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

6170: dbms_sql.define_column(v_cursor_adj_id, 26, l_vendor_id);
6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6177: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6178:

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

6171: dbms_sql.define_column(v_cursor_adj_id, 27, v_exp_organization_id);
6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6177: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6178:
6179:

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

6172: dbms_sql.define_column(v_cursor_adj_id, 28, v_incurred_by_person_id);
6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6177: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6178:
6179:
6180:

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

6173: dbms_sql.define_column(v_cursor_adj_id, 29, l_document_line_number);
6174: dbms_sql.define_column(v_cursor_adj_id, 30, l_document_distribution_id);
6175: dbms_sql.define_column(v_cursor_adj_id, 31, v_project_currency_code, 15);
6176: dbms_sql.define_column(v_cursor_adj_id, 32, l_tp_amt_type_code, 30);
6177: dbms_sql.define_column(v_cursor_adj_id, 33, v_nlr_organization_id);
6178:
6179:
6180:
6181:

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

6181:
6182:
6183:
6184: IF ( X_module IN ( 'PAXPRRPE','PAXPREPR','PAXBAUPD','PATXMAS') ) THEN
6185: v_open_cursor := dbms_sql.execute(v_cursor_adj_id);
6186: LOOP
6187: /* Fetch the rows into the buffer ************************* */
6188: IF P_DEBUG_MODE THEN
6189: print_message('get_denom_curr_code: ' || 'Fetch the rows into the buffer');

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

6188: IF P_DEBUG_MODE THEN
6189: print_message('get_denom_curr_code: ' || 'Fetch the rows into the buffer');
6190: END IF;
6191:
6192: If dbms_sql.fetch_rows(v_cursor_adj_id) = 0 then
6193: --Exit the loop once all the records are fetched
6194:
6195: exit ;
6196: end if ;

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

6195: exit ;
6196: end if ;
6197:
6198: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6199: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);

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

6196: end if ;
6197:
6198: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6199: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);

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

6197:
6198: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6199: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);

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

6198: /*** Retrieve the rows from the buffer into PLSQL variables ****/
6199: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);

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

6199: dbms_sql.column_value(v_cursor_adj_id, 1, v_expenditure_item_id);
6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);

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

6200: dbms_sql.column_value(v_cursor_adj_id, 2, v_exp_org_id);
6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);

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

6201: dbms_sql.column_value(v_cursor_adj_id, 3, l_project_id);
6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);

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

6202: dbms_sql.column_value(v_cursor_adj_id, 4, l_net_zero_adjustment_flag);
6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);

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

6203: dbms_sql.column_value(v_cursor_adj_id, 5, l_converted_flag);
6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);

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

6204: dbms_sql.column_value(v_cursor_adj_id, 6, l_expenditure_status_code);
6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);

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

6205: dbms_sql.column_value(v_cursor_adj_id, 7, l_burden_sum_dest_run_id);
6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);

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

6206: dbms_sql.column_value(v_cursor_adj_id, 8, l_document_header_id);
6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);

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

6207: dbms_sql.column_value(v_cursor_adj_id, 9, l_transaction_source);
6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);

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

6208: dbms_sql.column_value(v_cursor_adj_id, 10, l_document_type);
6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);

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

6209: dbms_sql.column_value(v_cursor_adj_id, 11, l_document_distribution_type);
6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);

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

6210: dbms_sql.column_value(v_cursor_adj_id, 12, l_document_payment_id);
6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);

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

6211: dbms_sql.column_value(v_cursor_adj_id, 13, l_source_expenditure_item_id);
6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);

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

6212: dbms_sql.column_value(v_cursor_adj_id, 14, v_system_linkage);
6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);

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

6213: dbms_sql.column_value(v_cursor_adj_id, 15, l_acct_currency_code);
6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);

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

6214: dbms_sql.column_value(v_cursor_adj_id, 16, v_denom_currency_code);
6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);

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

6215: dbms_sql.column_value(v_cursor_adj_id, 17, v_denom_tp_currency_code);
6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);

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

6216: dbms_sql.column_value(v_cursor_adj_id, 18, l_projfunc_currency_code);
6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);

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

6217: dbms_sql.column_value(v_cursor_adj_id, 19, v_cc_code);
6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);

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

6218: dbms_sql.column_value(v_cursor_adj_id, 20, l_adjusted_expenditure_item_id);
6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);

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

6219: dbms_sql.column_value(v_cursor_adj_id, 21, l_orig_transaction_reference);
6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);

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

6220: dbms_sql.column_value(v_cursor_adj_id, 22, v_exp_item_date);
6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);

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

6221: dbms_sql.column_value(v_cursor_adj_id, 23, l_billable_flag);
6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);

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

6222: dbms_sql.column_value(v_cursor_adj_id, 24, v_task_id);
6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);

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

6223: dbms_sql.column_value(v_cursor_adj_id, 25, v_exp_type);
6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6231: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);

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

6224: dbms_sql.column_value(v_cursor_adj_id, 26, l_vendor_id);
6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6231: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6232:

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

6225: dbms_sql.column_value(v_cursor_adj_id, 27, v_exp_organization_id);
6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6231: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6232:
6233: /* Bug 5441891 - Start */

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

6226: dbms_sql.column_value(v_cursor_adj_id, 28, v_incurred_by_person_id);
6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6231: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6232:
6233: /* Bug 5441891 - Start */
6234: IF l_project_id <> l_project_id_cache THEN

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

6227: dbms_sql.column_value(v_cursor_adj_id, 29, l_document_line_number);
6228: dbms_sql.column_value(v_cursor_adj_id, 30, l_document_distribution_id);
6229: dbms_sql.column_value(v_cursor_adj_id, 31, v_project_currency_code);
6230: dbms_sql.column_value(v_cursor_adj_id, 32, l_tp_amt_type_code);
6231: dbms_sql.column_value(v_cursor_adj_id, 33, v_nlr_organization_id);
6232:
6233: /* Bug 5441891 - Start */
6234: IF l_project_id <> l_project_id_cache THEN
6235: SELECT pt.project_type_class_code

Line 7069: dbms_sql.close_cursor(v_cursor_adj_id) ;

7065: -- procedure was called multiple times. Customer - Oakridge
7066: IF P_DEBUG_MODE THEN
7067: print_message('get_denom_curr_code: ' || 'close the cursor ');
7068: END IF;
7069: dbms_sql.close_cursor(v_cursor_adj_id) ;
7070:
7071: IF i >= 1 then
7072: IF X_adj_action <> 'INDIRECT COST RECALC' then
7073: IF P_DEBUG_MODE THEN