APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on PA_CONTROL_ITEMS

Line 1: package body pa_control_items_wf_client as

1: package body pa_control_items_wf_client as
2: /* $Header: PACIWFCB.pls 120.8.12020000.3 2013/03/19 14:28:59 svmohamm ship $ */
3: /*============================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 284: pa_control_items pci,

280: CURSOR get_project_mgr_party_id
281: IS
282: select hp.party_id
283: from pa_project_parties ppp,
284: pa_control_items pci,
285: hz_parties hp
286: where pci.ci_id = p_ci_id
287: and ppp.project_role_id = 1
288: and ppp.project_id = pci.project_id

Line 329: FROM pa_control_items pci, pa_ci_types_tl pct,

325: hp.party_name,
326: pcc.class_code classification,
327: pci.record_version_number record_version_number,
328: pl.meaning ci_type_class
329: FROM pa_control_items pci, pa_ci_types_tl pct,
330: pa_ci_types_b pcb, pa_lookups pl, hz_parties hp,
331: pa_class_codes pcc
332: WHERE ci_id = p_ci_id
333: and pci.ci_type_id = pct.ci_type_id

Line 390: 'plsqlclob:pa_control_items_workflow.show_clob_content/'||

386: wf_engine.SetItemAttrText(itemtype => p_item_type,
387: itemkey => p_item_key,
388: aname => 'CLOB_CONTENT',
389: avalue =>
390: 'plsqlclob:pa_control_items_workflow.show_clob_content/'||
391: p_ci_id);
392:
393:
394:

Line 767: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

763: OPEN get_prev_status(l_ci_id);
764: FETCH get_prev_status INTO l_prev_status, l_curr_status;
765: CLOSE get_prev_status;
766:
767: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
768: p_api_version => 1.0
769: ,p_init_msg_list => FND_API.G_TRUE
770: ,p_validate_only => FND_API.G_FALSE
771: ,p_ci_id => l_ci_id

Line 783: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

779:
780: fnd_message.set_name('PA', 'PA_CI_ERR_PM_WF_COMMENT');
781: l_comment := fnd_message.get;
782: DBMS_LOCK.SLEEP(1);
783: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
784: ,p_object_id => l_ci_id
785: ,p_type_code => 'CHANGE_STATUS'
786: ,p_status_type => 'CONTROL_ITEM'
787: ,p_new_project_status => l_prev_status

Line 860: FROM pa_control_items

856: CURSOR get_owner_id
857: is
858: SELECT
859: owner_id
860: FROM pa_control_items
861: WHERE ci_id = l_ci_id;
862:
863: l_role varchar2(30) := NULL;
864: l_role_users varchar2(30000) := NULL;

Line 1032: END pa_control_items_wf_client;

1028: END IF;
1029: END;
1030:
1031:
1032: END pa_control_items_wf_client;
1033: