[Home] [Help]
187: (SELECT segment1 from pa_projects_all pp where pp.project_id =ced.project_id ) ProjectNumber,
188: (SELECT task_number from pa_tasks pt where pt.task_id =ced.project_task_id ) ProjectTaskNumber,
189: csd.org_id,
190: cia.incident_number
191: FROM cs_cost_details csd,
192: cs_estimate_details ced,
193: cs_txn_billing_types ctb,
194: cs_incidents_all_b cia
195: WHERE cia.incident_id = ced.incident_id
1661: l_batch_name, --2 harcoded
1662: l_exp_ending_date , --3 Function newgetweekending(p_date in date) return date
1663: l_employee_num, --4 N/A - populate the person_id instead of this
1664: l_organization_name, --5 N/A - This is the name of the expenditure_org_id
1665: l_expenditure_item_date, --6 cs_cost_details.transaction_date
1666: l_project_number, --7 N/A - populate the project_id instead of this
1667: l_project_task_number, --8 N/A - populate the task_id instead of this
1668: l_expenditure_type , --9 comes from cs_projects.expenditure_type
1669: null, --10 N/A for service
1667: l_project_task_number, --8 N/A - populate the task_id instead of this
1668: l_expenditure_type , --9 comes from cs_projects.expenditure_type
1669: null, --10 N/A for service
1670: null, --11 N/A for service
1671: l_quantity, --12 cs_cost_details.quantity
1672: l_raw_cost , --13 cs_cost_details.extended_cost (cost should be in the OUs functional currency)
1673: null, --14 N/A for service
1674: l_transaction_status_code, --15 harcoded
1675: null, --16 Projects will assign this
1668: l_expenditure_type , --9 comes from cs_projects.expenditure_type
1669: null, --10 N/A for service
1670: null, --11 N/A for service
1671: l_quantity, --12 cs_cost_details.quantity
1672: l_raw_cost , --13 cs_cost_details.extended_cost (cost should be in the OUs functional currency)
1673: null, --14 N/A for service
1674: l_transaction_status_code, --15 harcoded
1675: null, --16 Projects will assign this
1676: null, --17 Projects will assign this
1673: null, --14 N/A for service
1674: l_transaction_status_code, --15 harcoded
1675: null, --16 Projects will assign this
1676: null, --17 Projects will assign this
1677: l_orig_ref, --18 cs_cost_details.cost_id
1678: null, --19 N/A for service Attribute 1--10
1679: null, --20 N/A for service
1680: null, --20 N/A for service
1681: null, --20 N/A for service
1689: null, --21 N/A - we have provided total cost , so this is not applciable
1690: null, --22 Projects will assign this
1691: l_UNMAT_NEG_TXN_FLAG, --23
1692: null, --24 Projects will assign this
1693: l_cost_org_id, --25 cs_cost_details.Operating Unit on the cost record
1694: null, --26 N/A for service , costs will go as unaccounted , this column is the ID of the GL debit account.
1695: null, --27 N/A for service , costs will go as unaccounted , this column is the ID of the GL credit account.
1696: null, --28 N/A for service ,the reference to the record in the external system if it has already been accounted for and interfaced to Oracle General Ledger
1697: null, --28
1710: sysdate, --38
1711: null, --39 N/A for service , as service does not handle receipts
1712: null, --40 N/A for service , as service does not handle receipts
1713: null, --41 N/A for service , as service does not handle receipts
1714: l_denom_currency_code, --42 cs_cost_details.currency_code
1715: l_raw_cost , --43 Service will calculate the qty x unit cost in the denom_currency_code and put the value in this column.
1716: null, --44 NA for service
1717: null, --45 NA for service
1718: null, --46 NA for service
1751: null, --79 NA for service
1752: null, --80 NA for service
1753: null, --81 NA for service
1754: null, --82 NA for service
1755: l_item_id, --83 cs_cost_details.inventory_item_id
1756: null, --84 NA for service
1757: l_uom, --85 cs_cost_details.unit_of_measure_code
1758: null, --86 NA for service
1759: null, --87 NA for service
1753: null, --81 NA for service
1754: null, --82 NA for service
1755: l_item_id, --83 cs_cost_details.inventory_item_id
1756: null, --84 NA for service
1757: l_uom, --85 cs_cost_details.unit_of_measure_code
1758: null, --86 NA for service
1759: null, --87 NA for service
1760: null, --88 NA for service
1761: null, --89 NA for service
1778:
1779:
1780: l_success_count := l_success_count+1;
1781:
1782: Update cs_cost_details set interfaced_to_pa_flag = 'T'
1783: where cost_id = l_cost_id;
1784:
1785:
1786: -- l_succ_cst_rec.EXTEND(1);
1845:
1846: l_failure_count := l_failure_count+1;
1847:
1848:
1849: Update cs_cost_details set interfaced_to_pa_flag = 'N'
1850: where cost_id = l_cost_id;
1851:
1852: -- l_err_cst_rec.EXTEND(1);
1853: l_err_cst_rec(j).cost_id :=l_cost_id ;
1875:
1876: l_failure_count := l_failure_count+1;
1877:
1878:
1879: Update cs_cost_details set interfaced_to_pa_flag = 'N'
1880: where cost_id = l_cost_id;
1881:
1882: l_err_cst_rec(j).cost_id :=l_cost_id ;
1883: l_err_cst_rec(j).incident_number :=l_incident_number ;
1991: For i in 1..l_err_cst_rec.count
1992: Loop
1993:
1994: /* select cost_id into l_err_cost_id
1995: from cs_cost_details
1996: where cost_id = l_err_cst_rec(i) ;*/
1997:
1998: fnd_file.put_line
1999: (
2070: Loop
2071:
2072: /*select cost_id
2073: into l_succ_cost_id
2074: from cs_cost_details
2075: where cost_id = l_succ_cst_rec(i) ;*/
2076:
2077:
2078:
2139: l_failure_count := l_failure_count+1;
2140:
2141:
2142:
2143: Update cs_cost_details set interfaced_to_pa_flag = 'N'
2144: where cost_id = l_cost_id;
2145:
2146: l_err_cst_rec(j).cost_id :=l_cost_id ;
2147: l_err_cst_rec(j).incident_number :=l_incident_number ;
2289: Open get_interface_status;
2290: Fetch get_interface_status into l_status_code ,l_cost_id;
2291:
2292:
2293: UPDATE cs_cost_details
2294: set interfaced_to_pa_flag = decode(l_status_code,'I','Y',
2295: 'R','E')
2296: where cost_id = l_cost_id;
2297: