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.4.12010000.2 2008/10/15 11:38:16 rthumma ship $ */
3: /*============================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 280: pa_control_items pci,

276: CURSOR get_project_mgr_party_id
277: IS
278: select hp.party_id
279: from pa_project_parties ppp,
280: pa_control_items pci,
281: hz_parties hp
282: where pci.ci_id = p_ci_id
283: and ppp.project_role_id = 1
284: and ppp.project_id = pci.project_id

Line 325: FROM pa_control_items pci, pa_ci_types_tl pct,

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

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

381: wf_engine.SetItemAttrText(itemtype => p_item_type,
382: itemkey => p_item_key,
383: aname => 'CLOB_CONTENT',
384: avalue =>
385: 'plsqlclob:pa_control_items_workflow.show_clob_content/'||
386: p_ci_id);
387:
388:
389:

Line 761: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

757: OPEN get_prev_status(l_ci_id);
758: FETCH get_prev_status INTO l_prev_status, l_curr_status;
759: CLOSE get_prev_status;
760:
761: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
762: p_api_version => 1.0
763: ,p_init_msg_list => FND_API.G_TRUE
764: ,p_validate_only => FND_API.G_FALSE
765: ,p_ci_id => l_ci_id

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

773:
774: fnd_message.set_name('PA', 'PA_CI_ERR_PM_WF_COMMENT');
775: l_comment := fnd_message.get;
776: DBMS_LOCK.SLEEP(1);
777: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
778: ,p_object_id => l_ci_id
779: ,p_type_code => 'CHANGE_STATUS'
780: ,p_status_type => 'CONTROL_ITEM'
781: ,p_new_project_status => l_prev_status

Line 854: FROM pa_control_items

850: CURSOR get_owner_id
851: is
852: SELECT
853: owner_id
854: FROM pa_control_items
855: WHERE ci_id = l_ci_id;
856:
857: l_role varchar2(30) := NULL;
858: l_role_users varchar2(30000) := NULL;

Line 923: END pa_control_items_wf_client;

919:
920: END;
921:
922:
923: END pa_control_items_wf_client;
924: