APPS.PA_CONTROL_ITEMS_PKG dependencies on PA_CONTROL_ITEMS

Line 1: PACKAGE BODY PA_CONTROL_ITEMS_PKG AS

1: PACKAGE BODY PA_CONTROL_ITEMS_PKG AS
2: --$Header: PACICITB.pls 120.3.12010000.7 2010/05/06 12:00:56 rrambati ship $
3:
4:
5: procedure INSERT_ROW (

Line 17: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676

13: ,p_classification_code IN NUMBER
14: ,p_reason_code IN NUMBER
15: ,p_project_id IN NUMBER
16: ,p_last_modified_by_id IN NUMBER
17: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
18: ,p_object_type IN VARCHAR2 := NULL
19: ,p_object_id IN NUMBER := NULL
20: ,p_ci_number IN VARCHAR2 := NULL
21: ,p_date_required IN DATE := NULL

Line 91: cursor C is select ROWID from PA_CONTROL_ITEMS

87: l_number_prefix varchar2(50) := NULL;
88: l_vers_num NUMBER :=3;
89: l_Current_Version_flag varchar2(1) := 'Y';
90:
91: cursor C is select ROWID from PA_CONTROL_ITEMS
92: where ci_id = px_ci_id;
93:
94: cursor vn_csr is select max(version_number) from PA_CONTROL_ITEMS
95: where Original_ci_id = p_Original_ci_id;

Line 94: cursor vn_csr is select max(version_number) from PA_CONTROL_ITEMS

90:
91: cursor C is select ROWID from PA_CONTROL_ITEMS
92: where ci_id = px_ci_id;
93:
94: cursor vn_csr is select max(version_number) from PA_CONTROL_ITEMS
95: where Original_ci_id = p_Original_ci_id;
96:
97: cursor curr_prefix is select prefix_auto_number from pa_ci_types_v
98: where ci_type_id = p_ci_type_id;

Line 106: SELECT pa_control_items_s.nextval

102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --get the unique control item id from the Oracle Sequence
105: IF (px_ci_id is null) THEN
106: SELECT pa_control_items_s.nextval
107: INTO l_ci_id
108: FROM DUAL;
109: px_ci_id := l_ci_id;
110: END IF;

Line 129: insert into PA_CONTROL_ITEMS (

125:
126: l_number_prefix := p_ci_number;
127:
128: END IF;
129: insert into PA_CONTROL_ITEMS (
130: ci_id
131: ,ci_type_id
132: ,summary
133: ,status_code

Line 317: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676

313: ,p_record_version_number IN NUMBER
314:
315: ,p_project_id IN NUMBER
316: ,p_last_modified_by_id IN NUMBER
317: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
318: ,p_object_type IN VARCHAR2 := NULL
319: ,p_object_id IN NUMBER := NULL
320: ,p_ci_number IN VARCHAR2 := NULL
321: ,p_date_required IN DATE := NULL

Line 383: update PA_CONTROL_ITEMS set

379: ) is
380: begin
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: update PA_CONTROL_ITEMS set
384: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
385: ,summary = Nvl(p_summary,summary)
386: ,status_code = Nvl(p_status_code, status_code)
387: ,owner_id = Nvl(p_owner_id,owner_id)

Line 478: DELETE FROM PA_CONTROL_ITEMS

474: ) is
475: begin
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477:
478: DELETE FROM PA_CONTROL_ITEMS
479: where ci_id = p_ci_id
480: and record_version_number = p_record_version_number;
481:
482:

Line 489: END PA_CONTROL_ITEMS_PKG;

485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: RAISE;
487: end DELETE_ROW;
488:
489: END PA_CONTROL_ITEMS_PKG;