DBA Data[Home] [Help]

APPS.JTF_QUALIFIER_PVT dependencies on JTF_QUALIFIER_PUB

Line 29: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

25:
26:
27: /* Insert seeded qualifier record into database */
28: PROCEDURE Create_Seed_Qual_Record
29: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
30: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
31:
32: /* Update seeded qualifier record in database */
33: PROCEDURE Update_Seed_Qual_Record

Line 30: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );

26:
27: /* Insert seeded qualifier record into database */
28: PROCEDURE Create_Seed_Qual_Record
29: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
30: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
31:
32: /* Update seeded qualifier record in database */
33: PROCEDURE Update_Seed_Qual_Record
34: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

Line 34: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

30: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
31:
32: /* Update seeded qualifier record in database */
33: PROCEDURE Update_Seed_Qual_Record
34: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
35: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
36:
37: /* Delete seeded qualifier record from database */
38: PROCEDURE Delete_Seed_Qual_Record

Line 35: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );

31:
32: /* Update seeded qualifier record in database */
33: PROCEDURE Update_Seed_Qual_Record
34: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
35: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type );
36:
37: /* Delete seeded qualifier record from database */
38: PROCEDURE Delete_Seed_Qual_Record
39: ( p_seeded_qual_id IN NUMBER,

Line 46: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

42:
43: /* Insert qualifier usage record into database */
44: PROCEDURE Create_Qual_Usgs_Record
45: ( p_seed_qual_id IN NUMBER,
46: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
47: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
48:
49: /* Update qualifier usage record in database */
50: PROCEDURE Update_Qual_Usgs_Record

Line 47: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);

43: /* Insert qualifier usage record into database */
44: PROCEDURE Create_Qual_Usgs_Record
45: ( p_seed_qual_id IN NUMBER,
46: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
47: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
48:
49: /* Update qualifier usage record in database */
50: PROCEDURE Update_Qual_Usgs_Record
51: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

Line 51: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

47: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
48:
49: /* Update qualifier usage record in database */
50: PROCEDURE Update_Qual_Usgs_Record
51: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
52: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
53:
54: /* Delete qualifier usage record from database */
55: PROCEDURE Delete_Qual_Usgs_Record

Line 52: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);

48:
49: /* Update qualifier usage record in database */
50: PROCEDURE Update_Qual_Usgs_Record
51: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
52: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
53:
54: /* Delete qualifier usage record from database */
55: PROCEDURE Delete_Qual_Usgs_Record
56: ( p_qual_usg_id IN NUMBER,

Line 79: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC

75: -- IN :
76: -- Required
77: -- Parameter Name Data Type Default
78: -- p_api_version NUMBER
79: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
80: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
81: --
82: -- Optional
83: -- Parameter Name Data Type Default

Line 80: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC

76: -- Required
77: -- Parameter Name Data Type Default
78: -- p_api_version NUMBER
79: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
80: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
81: --
82: -- Optional
83: -- Parameter Name Data Type Default
84: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

Line 111: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,

107: x_Return_Status OUT NOCOPY VARCHAR2,
108: x_Msg_Count OUT NOCOPY NUMBER,
109: x_Msg_Data OUT NOCOPY VARCHAR2,
110: -- commented eihsu 11/4
111: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
112: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
113: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
114: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
115:

Line 112: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,

108: x_Msg_Count OUT NOCOPY NUMBER,
109: x_Msg_Data OUT NOCOPY VARCHAR2,
110: -- commented eihsu 11/4
111: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
112: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
113: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
114: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
115:
116:

Line 113: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,

109: x_Msg_Data OUT NOCOPY VARCHAR2,
110: -- commented eihsu 11/4
111: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
112: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
113: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
114: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
115:
116:
117: -- ***************************************************

Line 114: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);

110: -- commented eihsu 11/4
111: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
112: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
113: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
114: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
115:
116:
117: -- ***************************************************
118: -- start of comments

Line 131: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC

127: -- IN :
128: -- Required
129: -- Parameter Name Data Type Default
130: -- p_api_version NUMBER
131: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
132: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
133: --
134: -- Optional
135: -- Parameter Name Data Type Default

Line 132: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC

128: -- Required
129: -- Parameter Name Data Type Default
130: -- p_api_version NUMBER
131: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
132: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
133: --
134: -- Optional
135: -- Parameter Name Data Type Default
136: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

Line 162: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,

158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_Return_Status OUT NOCOPY VARCHAR2,
160: x_Msg_Count OUT NOCOPY NUMBER,
161: x_Msg_Data OUT NOCOPY VARCHAR2,
162: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
163: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
164: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
165: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
166:

Line 163: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,

159: x_Return_Status OUT NOCOPY VARCHAR2,
160: x_Msg_Count OUT NOCOPY NUMBER,
161: x_Msg_Data OUT NOCOPY VARCHAR2,
162: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
163: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
164: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
165: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
166:
167:

Line 164: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,

160: x_Msg_Count OUT NOCOPY NUMBER,
161: x_Msg_Data OUT NOCOPY VARCHAR2,
162: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
163: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
164: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
165: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
166:
167:
168:

Line 165: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);

161: x_Msg_Data OUT NOCOPY VARCHAR2,
162: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
163: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
164: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
165: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type);
166:
167:
168:
169: