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 2007/02/08 11:30:15 sukhanna noship $
3:
4:
5: procedure INSERT_ROW (

Line 73: cursor C is select ROWID from PA_CONTROL_ITEMS

69: l_rowid ROWID;
70: l_ci_id NUMBER;
71:
72:
73: cursor C is select ROWID from PA_CONTROL_ITEMS
74: where ci_id = px_ci_id;
75:
76: BEGIN
77:

Line 82: SELECT pa_control_items_s.nextval

78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: --get the unique control item id from the Oracle Sequence
81: IF (px_ci_id is null) THEN
82: SELECT pa_control_items_s.nextval
83: INTO l_ci_id
84: FROM DUAL;
85: px_ci_id := l_ci_id;
86: END IF;

Line 89: insert into PA_CONTROL_ITEMS (

85: px_ci_id := l_ci_id;
86: END IF;
87:
88:
89: insert into PA_CONTROL_ITEMS (
90: ci_id
91: ,ci_type_id
92: ,summary
93: ,status_code

Line 299: update PA_CONTROL_ITEMS set

295: ) is
296: begin
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: update PA_CONTROL_ITEMS set
300: ci_type_id = Nvl(p_ci_type_id,ci_type_id)
301: ,summary = Nvl(p_summary,summary)
302: ,status_code = Nvl(p_status_code, status_code)
303: ,owner_id = Nvl(p_owner_id,owner_id)

Line 382: DELETE FROM PA_CONTROL_ITEMS

378: ) is
379: begin
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: DELETE FROM PA_CONTROL_ITEMS
383: where ci_id = p_ci_id
384: and record_version_number = p_record_version_number;
385:
386:

Line 393: END PA_CONTROL_ITEMS_PKG;

389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: RAISE;
391: end DELETE_ROW;
392:
393: END PA_CONTROL_ITEMS_PKG;