DBA Data[Home] [Help]

APPS.JTF_RS_DYNAMIC_GROUPS_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,

24: P_USAGE IN JTF_RS_DYNAMIC_GROUPS_B.USAGE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,

25: P_START_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,

26: P_END_DATE_ACTIVE IN JTF_RS_DYNAMIC_GROUPS_B.END_DATE_ACTIVE%TYPE DEFAULT NULL,
27: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,

27: P_SQL_TEXT IN JTF_RS_DYNAMIC_GROUPS_B.SQL_TEXT%TYPE,
28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,

28: P_ATTRIBUTE1 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE1%TYPE DEFAULT NULL,
29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,

29: P_ATTRIBUTE2 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE2%TYPE DEFAULT NULL,
30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,

30: P_ATTRIBUTE3 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE3%TYPE DEFAULT NULL,
31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,

31: P_ATTRIBUTE4 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE4%TYPE DEFAULT NULL,
32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,

32: P_ATTRIBUTE5 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE5%TYPE DEFAULT NULL,
33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,

33: P_ATTRIBUTE6 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE6%TYPE DEFAULT NULL,
34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,

34: P_ATTRIBUTE7 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE7%TYPE DEFAULT NULL,
35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,

35: P_ATTRIBUTE8 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE8%TYPE DEFAULT NULL,
36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,

36: P_ATTRIBUTE9 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE9%TYPE DEFAULT NULL,
37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,

37: P_ATTRIBUTE10 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE10%TYPE DEFAULT NULL,
38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,

38: P_ATTRIBUTE11 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE11%TYPE DEFAULT NULL,
39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,
46: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

39: P_ATTRIBUTE12 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE12%TYPE DEFAULT NULL,
40: P_ATTRIBUTE13 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE13%TYPE DEFAULT NULL,
41: P_ATTRIBUTE14 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE14%TYPE DEFAULT NULL,
42: P_ATTRIBUTE15 IN JTF_RS_GRP_RELATIONS.ATTRIBUTE15%TYPE DEFAULT NULL,
43: P_ATTRIBUTE_CATEGORY IN JTF_RS_GRP_RELATIONS.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,
46: X_MSG_DATA OUT NOCOPY VARCHAR2,
47: X_GROUP_ID OUT NOCOPY JTF_RS_DYNAMIC_GROUPS_B.GROUP_ID%TYPE,