APPS.PA_RESOURCE_PKG dependencies on PA_RESOURCES

Line 5: /* THE INSERT_ROW1 PROCEDURE INSERTS INTO PA_RESOURCES TABLE.

1: PACKAGE BODY PA_RESOURCE_PKG
2: -- $Header: PARCTBHB.pls 120.1 2005/08/19 16:49:47 mwasowic noship $
3: AS
4:
5: /* THE INSERT_ROW1 PROCEDURE INSERTS INTO PA_RESOURCES TABLE.
6: THE INSERT_ROW2 PROCEDURE INSERTS INTO PA_RESOURCE_TXN_ATTRIBUTES TABLE.
7: THE INSERT_ROW3 PROCEDURE INSERTS INTO PA_RESOURCE_OU TABLE.*/
8:
9: PROCEDURE INSERT_ROW1(

Line 11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,

7: THE INSERT_ROW3 PROCEDURE INSERTS INTO PA_RESOURCE_OU TABLE.*/
8:
9: PROCEDURE INSERT_ROW1(
10: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,

Line 12: X_NAME IN PA_RESOURCES.NAME%TYPE,

8:
9: PROCEDURE INSERT_ROW1(
10: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,

Line 13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,

9: PROCEDURE INSERT_ROW1(
10: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
17: X_REQUEST_ID IN NUMBER,

Line 14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,

10: X_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
17: X_REQUEST_ID IN NUMBER,
18: X_PROGRAM_ID IN NUMBER,

Line 15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,

11: X_RESOURCE_ID IN PA_RESOURCES.RESOURCE_ID%TYPE,
12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
17: X_REQUEST_ID IN NUMBER,
18: X_PROGRAM_ID IN NUMBER,
19: X_PROGRAM_UPDATE_DATE IN DATE,

Line 16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,

12: X_NAME IN PA_RESOURCES.NAME%TYPE,
13: X_RESOURCE_TYPE_ID IN PA_RESOURCES.RESOURCE_TYPE_ID%TYPE,
14: X_JTF_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
15: X_START_DATE_ACTIVE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
16: X_END_DATE_ACTIVE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE,
17: X_REQUEST_ID IN NUMBER,
18: X_PROGRAM_ID IN NUMBER,
19: X_PROGRAM_UPDATE_DATE IN DATE,
20: X_PROGRAM_APPLICATION_ID IN NUMBER,

Line 21: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, --added for bug 2599790

17: X_REQUEST_ID IN NUMBER,
18: X_PROGRAM_ID IN NUMBER,
19: X_PROGRAM_UPDATE_DATE IN DATE,
20: X_PROGRAM_APPLICATION_ID IN NUMBER,
21: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, --added for bug 2599790
22: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
23: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
24: X_LAST_UPDATE_BY IN NUMBER,
25: X_LAST_UPDATE_DATE IN DATE,

Line 22: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534

18: X_PROGRAM_ID IN NUMBER,
19: X_PROGRAM_UPDATE_DATE IN DATE,
20: X_PROGRAM_APPLICATION_ID IN NUMBER,
21: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, --added for bug 2599790
22: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
23: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
24: X_LAST_UPDATE_BY IN NUMBER,
25: X_LAST_UPDATE_DATE IN DATE,
26: X_CREATION_DATE IN DATE,

Line 23: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534

19: X_PROGRAM_UPDATE_DATE IN DATE,
20: X_PROGRAM_APPLICATION_ID IN NUMBER,
21: X_UNIT_OF_MEASURE IN PA_RESOURCES.UNIT_OF_MEASURE%TYPE, --added for bug 2599790
22: X_ROLLUP_QUANTITY_FLAG IN PA_RESOURCES.ROLLUP_QUANTITY_FLAG%TYPE, --added for bug 3921534
23: X_TRACK_AS_LABOR_FLAG IN PA_RESOURCES.TRACK_AS_LABOR_FLAG%TYPE, --added for bug 3921534
24: X_LAST_UPDATE_BY IN NUMBER,
25: X_LAST_UPDATE_DATE IN DATE,
26: X_CREATION_DATE IN DATE,
27: X_CREATED_BY IN NUMBER,

Line 35: select rowid from pa_resources

31: l_check_dup_id VARCHAR2(1);
32: --l_resource_id NUMBER;
33: --cursor to select rowid of current insert
34: cursor C is
35: select rowid from pa_resources
36: where resource_id = x_resource_id;
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:

Line 40: --actual insert into pa_resources table

36: where resource_id = x_resource_id;
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: --actual insert into pa_resources table
41: insert into PA_RESOURCES (
42: resource_id,
43: name,
44: description, -- Added for bug 4318765

Line 41: insert into PA_RESOURCES (

37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: --actual insert into pa_resources table
41: insert into PA_RESOURCES (
42: resource_id,
43: name,
44: description, -- Added for bug 4318765
45: resource_type_id,