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_CI_SUPPLIER_UTILS dependencies on PA_CI_SUPPLIER_DETAILS

Line 14: / This API checks whether the record exists or not in pa_ci_supplier_details /

10: NULL;
11:
12: END print_msg;
13:
14: /** This API checks whether the record exists or not in pa_ci_supplier_details **/
15: FUNCTION check_trx_exists(p_ci_transaction_id in NUMBER)
16: RETURN VARCHAR2 IS
17: l_return_status varchar2(1) := 'N';
18: BEGIN

Line 24: FROM pa_ci_supplier_details

20: IF p_ci_transaction_id is NOT NULL then
21:
22: SELECT 'Y'
23: INTO l_return_status
24: FROM pa_ci_supplier_details
25: WHERE ci_transaction_id = p_ci_transaction_id;
26:
27: ELSE
28: l_return_status := 'N';

Line 68: from pa_ci_supplier_details

64: -- Cursor to check whether supplier record is unique if
65: -- Change type is 'Create New', during SC Line create
66: cursor is_supp_cost_rec_exist_cre_1 is
67: select 'Y'
68: from pa_ci_supplier_details
69: where ci_id = p_ci_id
70: and task_id = p_task_id
71: and resource_list_member_id = p_resource_list_mem_id
72: and expenditure_type = p_expenditure_type

Line 83: from pa_ci_supplier_details

79: -- Cursor to check whether supplier record is unique if
80: -- Change type is 'Update Existing', during SC Line create
81: cursor is_supp_cost_rec_exist_cre_2 is
82: select 'Y'
83: from pa_ci_supplier_details
84: where ci_id = p_ci_id
85: and task_id = p_task_id
86: and resource_list_member_id = p_resource_list_mem_id
87: and expenditure_type = p_expenditure_type

Line 107: from pa_ci_supplier_details

103: -- Cursor to check whether supplier record is unique if
104: -- Change type is 'Create New' during Update SC Line
105: cursor is_supp_cost_rec_exist_upd_1 is
106: select 'Y'
107: from pa_ci_supplier_details
108: where ci_id = p_ci_id
109: and task_id = p_task_id
110: and resource_list_member_id = p_resource_list_mem_id
111: and expenditure_type = p_expenditure_type

Line 123: from pa_ci_supplier_details

119: -- Cursor to check whether supplier record is unique if
120: -- Change type is 'Update Existing' during Update SC Line
121: cursor is_supp_cost_rec_exist_upd_2 is
122: select 'Y'
123: from pa_ci_supplier_details
124: where ci_id = p_ci_id
125: and task_id = p_task_id
126: and resource_list_member_id = p_resource_list_mem_id
127: and expenditure_type = p_expenditure_type

Line 1340: INSERT INTO PA_CI_SUPPLIER_DETAILS

1336:
1337: IF p_from_ci_item_id is NOT NULL and
1338: p_to_ci_item_id is NOT NULL Then
1339:
1340: INSERT INTO PA_CI_SUPPLIER_DETAILS
1341: (
1342: CI_TRANSACTION_ID
1343: ,CI_TYPE_ID
1344: ,CI_ID

Line 1361: PA_CI_SUPPLIER_DETAILS_S.nextval

1357: ,LAST_UPDATE_DATE
1358: ,LAST_UPDATE_LOGIN
1359: )
1360: SELECT
1361: PA_CI_SUPPLIER_DETAILS_S.nextval
1362: ,ci.CI_TYPE_ID
1363: ,p_to_ci_item_id
1364: ,si.CI_IMPACT_ID
1365: ,si.VENDOR_ID

Line 1378: FROM PA_CI_SUPPLIER_DETAILS si

1374: ,sysdate
1375: ,NVL(FND_GLOBAL.login_id,-99)
1376: ,sysdate
1377: ,NVL(FND_GLOBAL.login_id,-99)
1378: FROM PA_CI_SUPPLIER_DETAILS si
1379: ,PA_CONTROL_ITEMS ci
1380: WHERE si.CI_ID = p_from_ci_item_id
1381: AND ci.ci_id = p_to_ci_item_id;
1382:

Line 1424: DELETE FROM PA_CI_SUPPLIER_DETAILS

1420: x_MSG_DATA := null;
1421: X_MSG_COUNT := 0;
1422:
1423: If nvl(p_ci_id ,0) <> 0 then
1424: DELETE FROM PA_CI_SUPPLIER_DETAILS
1425: WHERE ci_id = p_ci_id;
1426: commit;
1427:
1428: End if;

Line 1458: FROM pa_ci_supplier_details

1454: ) IS
1455:
1456: cursor c1 is
1457: SELECT CI_TRANSACTION_ID
1458: FROM pa_ci_supplier_details
1459: WHERE ci_id = p_ci_id;
1460:
1461: l_ci_transaction_id Number;
1462: l_msg_index_out Number;

Line 1720: FROM pa_ci_supplier_details_v

1716: l_ci_id := p_ci_id;
1717:
1718: if l_ci_id is not null then
1719: SELECT sum(change_amount) INTO total_cost
1720: FROM pa_ci_supplier_details_v
1721: WHERE
1722: ci_id = l_ci_id;
1723: else
1724: print_msg('Project Id cannot be null');

Line 2019: from pa_ci_supplier_details

2015: cursor get_sc_line(c_sc_line_id number) is
2016: select nvl(raw_cost, 0) raw_cost,
2017: from_change_date, to_change_date,
2018: burdened_cost
2019: from pa_ci_supplier_details
2020: where ci_id = p_ci_id
2021: and ci_transaction_id = c_sc_line_id;
2022:
2023: sc_line_row get_sc_line%ROWTYPE;

Line 2349: update pa_ci_supplier_details pcsc

2345: -- burdened cost in supplier details table after
2346: -- processing the supplier records and createing/updating
2347: -- resource assignments
2348: forall i in b_ins_task_id_tbl.first..b_ins_task_id_tbl.last
2349: update pa_ci_supplier_details pcsc
2350: set (resource_assignment_id, FROM_CHANGE_DATE,
2351: TO_CHANGE_DATE, burdened_cost) =
2352: (select prac.resource_assignment_id,
2353: decode(pcsc.FROM_CHANGE_DATE,

Line 2400: update pa_ci_supplier_details pcsc

2396: -- burdened cost in supplier details table after
2397: -- processing the supplier records and createing/updating
2398: -- resource assignments
2399: forall i in b_upd_task_id_tbl.first..b_upd_task_id_tbl.last
2400: update pa_ci_supplier_details pcsc
2401: set (resource_assignment_id, FROM_CHANGE_DATE,
2402: TO_CHANGE_DATE, burdened_cost) =
2403: (select prac.resource_assignment_id,
2404: decode(pcsc.FROM_CHANGE_DATE,