APPS.JTF_TERR_RSC_ACCESS_PKG dependencies on FND_API

Line 45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),

41: TRANS_ACCESS_CODE,
42: ORG_ID
43: ) VALUES (
44: x_TERR_RSC_ACCESS_ID,
45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

Line 46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),

42: ORG_ID
43: ) VALUES (
44: x_TERR_RSC_ACCESS_ID,
45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),

Line 47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),

43: ) VALUES (
44: x_TERR_RSC_ACCESS_ID,
45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),

Line 48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),

44: x_TERR_RSC_ACCESS_ID,
45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),

Line 49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),

45: decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_LAST_UPDATE_DATE),
46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),
53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)

Line 50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),

46: decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATED_BY),
47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),
53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)
54: );

Line 51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),

47: decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_CREATION_DATE),
48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),
53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)
54: );
55: OPEN C;

Line 52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),

48: decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL,x_CREATED_BY),
49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),
53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)
54: );
55: OPEN C;
56: FETCH C INTO x_Rowid;

Line 53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)

49: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,x_LAST_UPDATE_LOGIN),
50: decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM, NULL,x_TERR_RSC_ID),
51: decode( x_ACCESS_TYPE, FND_API.G_MISS_CHAR, NULL,x_ACCESS_TYPE),
52: decode( x_TRANS_ACCESS_CODE, FND_API.G_MISS_CHAR, NULL,x_TRANS_ACCESS_CODE),
53: decode( x_ORG_ID, FND_API.G_MISS_NUM, NULL,x_ORG_ID)
54: );
55: OPEN C;
56: FETCH C INTO x_Rowid;
57: If (C%NOTFOUND) then

Line 93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),

89: ) IS
90: BEGIN
91: Update JTF_TERR_RSC_ACCESS_ALL
92: SET
93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

Line 94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),

90: BEGIN
91: Update JTF_TERR_RSC_ACCESS_ALL
92: SET
93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

Line 95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),

91: Update JTF_TERR_RSC_ACCESS_ALL
92: SET
93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),

Line 96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),

92: SET
93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),

Line 97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),

93: TERR_RSC_ACCESS_ID = decode( x_TERR_RSC_ACCESS_ID, FND_API.G_MISS_NUM,TERR_RSC_ACCESS_ID,x_TERR_RSC_ACCESS_ID),
94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),

Line 98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),

94: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,LAST_UPDATE_DATE,x_LAST_UPDATE_DATE),
95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),
102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

Line 99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),

95: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM,LAST_UPDATED_BY,x_LAST_UPDATED_BY),
96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),
102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
103: where TERR_RSC_ACCESS_ID = X_TERR_RSC_ACCESS_ID;

Line 100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),

96: CREATION_DATE = decode( x_CREATION_DATE, FND_API.G_MISS_DATE,CREATION_DATE,x_CREATION_DATE),
97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),
102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
103: where TERR_RSC_ACCESS_ID = X_TERR_RSC_ACCESS_ID;
104:

Line 101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),

97: CREATED_BY = decode( x_CREATED_BY, FND_API.G_MISS_NUM,CREATED_BY,x_CREATED_BY),
98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),
102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
103: where TERR_RSC_ACCESS_ID = X_TERR_RSC_ACCESS_ID;
104:
105: If (SQL%NOTFOUND) then

Line 102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)

98: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,LAST_UPDATE_LOGIN,x_LAST_UPDATE_LOGIN),
99: TERR_RSC_ID = decode( x_TERR_RSC_ID, FND_API.G_MISS_NUM,TERR_RSC_ID,x_TERR_RSC_ID),
100: ACCESS_TYPE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,ACCESS_TYPE,x_ACCESS_TYPE),
101: TRANS_ACCESS_CODE = decode( x_ORG_ID, FND_API.G_MISS_CHAR,TRANS_ACCESS_CODE,x_TRANS_ACCESS_CODE),
102: ORG_ID = decode( x_ORG_ID, FND_API.G_MISS_NUM,ORG_ID,x_ORG_ID)
103: where TERR_RSC_ACCESS_ID = X_TERR_RSC_ACCESS_ID;
104:
105: If (SQL%NOTFOUND) then
106: RAISE NO_DATA_FOUND;