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

Line 60: from pa_ci_supplier_details

56: ,x_error_msg_code OUT NOCOPY VARCHAR2
57: )IS
58: cursor return_rowid is
59: select rowid
60: from pa_ci_supplier_details
61: where ci_transaction_id = x_CI_TRANSACTION_ID;
62:
63: cursor get_itemid is
64: select pa_ci_supplier_details_s.nextval

Line 64: select pa_ci_supplier_details_s.nextval

60: from pa_ci_supplier_details
61: where ci_transaction_id = x_CI_TRANSACTION_ID;
62:
63: cursor get_itemid is
64: select pa_ci_supplier_details_s.nextval
65: from sys.dual;
66:
67: cursor get_budget_data(bvId number) is
68: select prac.total_projfunc_burdened_cost , prac.total_projfunc_revenue, prac.txn_average_bill_rate

Line 85: select final_cost from pa_ci_supplier_details

81: select pa_resource_assignments_s.nextval
82: from sys.dual;
83:
84: cursor get_burdened_cost(ci_trans_id number) is
85: select final_cost from pa_ci_supplier_details
86: where ci_transaction_id = ci_trans_id;
87:
88: cursor get_budget_version_id is
89: select budget_version_id

Line 345: INSERT into pa_ci_supplier_details

341: l_revenue := (p_CHANGE_AMOUNT*l_cost_rate)*l_revenue_rate;
342: end if;
343: end if;
344:
345: INSERT into pa_ci_supplier_details
346: ( CI_TRANSACTION_ID
347: ,CI_TYPE_ID
348: ,CI_ID
349: ,CI_IMPACT_ID

Line 447: update pa_ci_supplier_details set CURRENT_AUDIT_FLAG = 'N' where ci_transaction_id = l_source_supp_id;

443: ,to_date(p_need_by_date)
444: -- gboomina modified for supplier cost 12.1.3 requirement - end
445: );
446: IF (l_audit_history_number > 1) then
447: update pa_ci_supplier_details set CURRENT_AUDIT_FLAG = 'N' where ci_transaction_id = l_source_supp_id;
448: end if;
449: /*
450: OPEN return_rowid;
451: FETCH return_rowid into x_rowid;

Line 591: --updating the pa_ci_supplier_details table information

587: --fetch burdened_cost, revenue_rate, revenue from budget tables
588: open get_budget_data(l_bvId);
589: fetch get_budget_data into l_burdened_cost, l_revenue, l_revenue_rate;
590: close get_budget_data;
591: --updating the pa_ci_supplier_details table information
592:
593: update pa_ci_supplier_details
594: set burdened_cost = l_burdened_cost,
595: revenue_rate = l_revenue_rate,

Line 593: update pa_ci_supplier_details

589: fetch get_budget_data into l_burdened_cost, l_revenue, l_revenue_rate;
590: close get_budget_data;
591: --updating the pa_ci_supplier_details table information
592:
593: update pa_ci_supplier_details
594: set burdened_cost = l_burdened_cost,
595: revenue_rate = l_revenue_rate,
596: revenue_override_rate = '',
597: revenue = l_revenue,

Line 879: --updating the pa_ci_supplier_details table information

875:
876: open get_budget_data(l_bvId);
877: fetch get_budget_data into l_burdened_cost, l_revenue, l_revenue_rate;
878: close get_budget_data;
879: --updating the pa_ci_supplier_details table information
880:
881: update pa_ci_supplier_details
882: set change_amount = p_CHANGE_AMOUNT,
883: burdened_cost = l_burdened_cost,

Line 881: update pa_ci_supplier_details

877: fetch get_budget_data into l_burdened_cost, l_revenue, l_revenue_rate;
878: close get_budget_data;
879: --updating the pa_ci_supplier_details table information
880:
881: update pa_ci_supplier_details
882: set change_amount = p_CHANGE_AMOUNT,
883: burdened_cost = l_burdened_cost,
884: revenue_rate = l_revenue_rate,
885: revenue_override_rate = '',

Line 958: from pa_ci_supplier_details

954: ,x_error_msg_code OUT NOCOPY VARCHAR2
955: )IS
956: cursor cur_audit is
957: select nvl(audit_history_number,0),original_supp_trans_id
958: from pa_ci_supplier_details
959: where ci_transaction_id = p_ci_transaction_id;
960:
961: cursor get_res_asgn_id is
962: select pa_resource_assignments_s.nextval

Line 998: FROM pa_ci_supplier_details

994: ,change_reason_code
995: ,quote_negotiation_reference
996: ,need_by_date
997: -- gboomina modified for supplier cost 12.1.3 requirement - end
998: FROM pa_ci_supplier_details
999: WHERE ci_transaction_id = p_ci_transaction_id
1000: FOR UPDATE OF ci_transaction_id NOWAIT;
1001:
1002: cursor get_budget_version_id is

Line 1144: UPDATE pa_ci_supplier_details SET

1140: If l_debug_mode = 'Y' Then
1141: print_msg('firing update query');
1142: End If;
1143:
1144: UPDATE pa_ci_supplier_details SET
1145: VENDOR_ID = p_vendor_id
1146: ,PO_HEADER_ID = p_po_header_id
1147: ,PO_LINE_ID = p_po_line_id
1148: ,ADJUSTED_CI_TRANSACTION_ID = p_adjusted_transaction_id

Line 1426: from pa_ci_supplier_details

1422: PROCEDURE delete_row (p_ci_transaction_id in NUMBER)IS
1423:
1424: cursor fetch_details is
1425: select TASK_ID, RESOURCE_LIST_MEMBER_ID, ci_id
1426: from pa_ci_supplier_details
1427: where CI_TRANSACTION_ID = p_ci_transaction_id;
1428:
1429: cursor get_budget_version_id(p_ci_id number) is
1430: select budget_version_id

Line 1472: DELETE FROM PA_CI_SUPPLIER_DETAILS

1468: open fetch_details;
1469: fetch fetch_details into l_task_id, l_res_id, l_ci_id;
1470: close fetch_details;
1471:
1472: DELETE FROM PA_CI_SUPPLIER_DETAILS
1473: WHERE CI_TRANSACTION_ID = P_CI_TRANSACTION_ID;
1474: if sql%found then
1475: If l_debug_mode = 'Y' Then
1476: print_msg('Delete Success');

Line 1528: from pa_ci_supplier_details

1524: PROCEDURE delete_row (x_rowid in VARCHAR2)IS
1525:
1526: cursor get_itemid is
1527: select ci_transaction_id
1528: from pa_ci_supplier_details
1529: where rowid = x_rowid;
1530:
1531: l_ci_transaction_id Number;
1532: