eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_QUALIFIER_PVT dependencies on JTF_QUALIFIER_PUB

Line 53: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type)

49: /* Returns TRUE if mandatory information is missing from record,
50: ** otherwise returns FALSE if information is complete
51: */
52: FUNCTION is_seed_qual_rec_missing
53: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type)
54: RETURN VARCHAR2
55: IS
56: BEGIN
57:

Line 76: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

72: ** All mandatory items are present
73: ** Convert missing values to defaults
74: */
75: PROCEDURE validate_seed_qual_rec
76: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
77: p_validation_mode IN VARCHAR2,
78: p_validation_level IN NUMBER,
79: x_return_status OUT NOCOPY VARCHAR2)
80: IS

Line 83: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := p_seed_qual_rec;

79: x_return_status OUT NOCOPY VARCHAR2)
80: IS
81: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
82:
83: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := p_seed_qual_rec;
84:
85: BEGIN
86:
87:

Line 125: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

121:
122:
123: /* Insert seeded qualifier record into database */
124: PROCEDURE Create_Seed_Qual_Record
125: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
126: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )
127: IS
128:
129: CURSOR c_chk_qual_name (l_qual_name VARCHAR2) IS

Line 126: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )

122:
123: /* Insert seeded qualifier record into database */
124: PROCEDURE Create_Seed_Qual_Record
125: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
126: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )
127: IS
128:
129: CURSOR c_chk_qual_name (l_qual_name VARCHAR2) IS
130: SELECT seeded_qual_id

Line 137: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;

133:
134: l_seeded_qual_id_csr NUMBER;
135:
136: l_rowid ROWID;
137: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;
138: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;
139:
140: BEGIN
141:

Line 138: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;

134: l_seeded_qual_id_csr NUMBER;
135:
136: l_rowid ROWID;
137: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;
138: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;
139:
140: BEGIN
141:
142: -- Initialise API return status to success

Line 208: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,

204:
205:
206: -- Update seeded qualifier record in database
207: PROCEDURE Update_Seed_Qual_Record
208: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
209: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )
210: IS
211:
212: l_rowid ROWID;

Line 209: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )

205:
206: -- Update seeded qualifier record in database
207: PROCEDURE Update_Seed_Qual_Record
208: ( p_seed_qual_rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type,
209: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )
210: IS
211:
212: l_rowid ROWID;
213: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;

Line 213: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;

209: x_seed_qual_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type )
210: IS
211:
212: l_rowid ROWID;
213: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;
214: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;
215:
216: BEGIN
217: -- Initialise API return status to success

Line 214: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;

210: IS
211:
212: l_rowid ROWID;
213: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC;
214: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_OUT_REC;
215:
216: BEGIN
217: -- Initialise API return status to success
218: l_seed_qual_out_rec.return_status := FND_API.G_RET_STS_SUCCESS;

Line 360: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

356: ----------------------------------------------------------------------
357:
358: -- Converts missing items' values to default values
359: PROCEDURE convert_miss_qual_usgs_rec
360: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
361: x_qual_usgs_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)
362: IS
363:
364: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;

Line 361: x_qual_usgs_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)

357:
358: -- Converts missing items' values to default values
359: PROCEDURE convert_miss_qual_usgs_rec
360: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
361: x_qual_usgs_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)
362: IS
363:
364: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
365:

Line 364: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;

360: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
361: x_qual_usgs_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)
362: IS
363:
364: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
365:
366: BEGIN
367:
368: IF (l_qual_usgs_rec.enabled_flag = FND_API.G_MISS_CHAR) THEN

Line 413: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)

409:
410: -- Returns TRUE if mandatory information is missing from record,
411: -- otherwise returns FALSE if information is complete
412: FUNCTION is_qual_usgs_rec_missing
413: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)
414: RETURN VARCHAR2
415: IS
416: BEGIN
417:

Line 546: ( p_qual_usgs_rec IN OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)

542: ** value, so that the record can still be inserted into the database
543: ** Checks items that use lookup values
544: */
545: FUNCTION qual_usgs_info_is_valid
546: ( p_qual_usgs_rec IN OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type)
547: RETURN VARCHAR2
548: IS
549:
550: /* return varaible */

Line 554: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;

550: /* return varaible */
551: l_return_variable VARCHAR2(1) := FND_API.G_TRUE;
552:
553: /* local scratch record */
554: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
555:
556: BEGIN
557:
558:

Line 586: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

582: ** All mandatory items are present
583: ** Convert missing values to defaults
584: */
585: PROCEDURE validate_qual_usgs_rec
586: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
587: p_validation_mode IN VARCHAR2,
588: p_validation_level IN NUMBER,
589: x_return_status OUT NOCOPY VARCHAR2)
590: IS

Line 605: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;

601: -- Initialise return status
602: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
603:
604: -- Initialise local Qualifer Usages record
605: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := p_qual_usgs_rec;
606:
607: BEGIN
608:
609:

Line 778: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

774:
775: -- Insert qualifier usage record into database
776: PROCEDURE Create_Qual_Usgs_Record
777: ( p_seed_qual_id IN NUMBER,
778: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
779: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)
780: IS
781:
782: l_return_csr VARCHAR2(1);

Line 779: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)

775: -- Insert qualifier usage record into database
776: PROCEDURE Create_Qual_Usgs_Record
777: ( p_seed_qual_id IN NUMBER,
778: p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
779: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)
780: IS
781:
782: l_return_csr VARCHAR2(1);
783:

Line 785: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;

781:
782: l_return_csr VARCHAR2(1);
783:
784: l_rowid ROWID;
785: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;
786: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;
787:
788: BEGIN
789:

Line 786: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;

782: l_return_csr VARCHAR2(1);
783:
784: l_rowid ROWID;
785: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;
786: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;
787:
788: BEGIN
789:
790: l_qual_usgs_rec := p_qual_usgs_rec;

Line 872: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,

868:
869:
870: -- Update qualifier usage record in database
871: PROCEDURE Update_Qual_Usgs_Record
872: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
873: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)
874: IS
875:
876: l_rowid ROWID;

Line 873: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)

869:
870: -- Update qualifier usage record in database
871: PROCEDURE Update_Qual_Usgs_Record
872: ( p_qual_usgs_rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type,
873: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)
874: IS
875:
876: l_rowid ROWID;
877: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;

Line 877: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;

873: x_qual_usgs_out_rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type)
874: IS
875:
876: l_rowid ROWID;
877: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;
878: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;
879:
880: BEGIN
881:

Line 878: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;

874: IS
875:
876: l_rowid ROWID;
877: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC;
878: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_OUT_REC;
879:
880: BEGIN
881:
882:

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

1120: -- IN :
1121: -- Required
1122: -- Parameter Name Data Type Default
1123: -- p_api_version NUMBER
1124: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
1125: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1126: --
1127: -- Optional
1128: -- Parameter Name Data Type Default

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

1121: -- Required
1122: -- Parameter Name Data Type Default
1123: -- p_api_version NUMBER
1124: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
1125: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1126: --
1127: -- Optional
1128: -- Parameter Name Data Type Default
1129: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

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

1152: x_Return_Status OUT NOCOPY VARCHAR2,
1153: x_Msg_Count OUT NOCOPY NUMBER,
1154: x_Msg_Data OUT NOCOPY VARCHAR2,
1155: -- commented eihsu 11/04
1156: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1157: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1158: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1159: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1160: )

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

1153: x_Msg_Count OUT NOCOPY NUMBER,
1154: x_Msg_Data OUT NOCOPY VARCHAR2,
1155: -- commented eihsu 11/04
1156: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1157: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1158: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1159: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1160: )
1161: IS

Line 1158: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,

1154: x_Msg_Data OUT NOCOPY VARCHAR2,
1155: -- commented eihsu 11/04
1156: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1157: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1158: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1159: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1160: )
1161: IS
1162: l_api_name CONSTANT VARCHAR2(30) := 'Create_Qualifier';

Line 1159: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type

1155: -- commented eihsu 11/04
1156: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1157: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type ,--:= JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1158: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1159: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1160: )
1161: IS
1162: l_api_name CONSTANT VARCHAR2(30) := 'Create_Qualifier';
1163: l_api_version CONSTANT NUMBER := 1.0;

Line 1166: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;

1162: l_api_name CONSTANT VARCHAR2(30) := 'Create_Qualifier';
1163: l_api_version CONSTANT NUMBER := 1.0;
1164: l_return_status VARCHAR2(1);
1165:
1166: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1167: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1168:
1169: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1170: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;

Line 1167: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;

1163: l_api_version CONSTANT NUMBER := 1.0;
1164: l_return_status VARCHAR2(1);
1165:
1166: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1167: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1168:
1169: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1170: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1171:

Line 1169: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;

1165:
1166: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1167: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1168:
1169: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1170: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1171:
1172: /* variable for qualifier disable eligibility test */
1173: l_qualifier_used VARCHAR2(30);

Line 1170: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;

1166: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1167: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1168:
1169: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1170: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1171:
1172: /* variable for qualifier disable eligibility test */
1173: l_qualifier_used VARCHAR2(30);
1174:

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

1395: -- IN :
1396: -- Required
1397: -- Parameter Name Data Type Default
1398: -- p_api_version NUMBER
1399: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
1400: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1401: --
1402: -- Optional
1403: -- Parameter Name Data Type Default

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

1396: -- Required
1397: -- Parameter Name Data Type Default
1398: -- p_api_version NUMBER
1399: -- p_Seed_Qual_Rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC
1400: -- p_Qual_Usgs_Rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC
1401: --
1402: -- Optional
1403: -- Parameter Name Data Type Default
1404: -- P_Init_Msg_List VARCHAR2 FND_API.G_FALSE

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

1426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1427: x_Return_Status OUT NOCOPY VARCHAR2,
1428: x_Msg_Count OUT NOCOPY NUMBER,
1429: x_Msg_Data OUT NOCOPY VARCHAR2,
1430: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1431: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1432: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1433: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1434: )

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

1427: x_Return_Status OUT NOCOPY VARCHAR2,
1428: x_Msg_Count OUT NOCOPY NUMBER,
1429: x_Msg_Data OUT NOCOPY VARCHAR2,
1430: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1431: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1432: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1433: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1434: )
1435: IS

Line 1432: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,

1428: x_Msg_Count OUT NOCOPY NUMBER,
1429: x_Msg_Data OUT NOCOPY VARCHAR2,
1430: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1431: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1432: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1433: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1434: )
1435: IS
1436: l_api_name CONSTANT VARCHAR2(30) := 'Update_Qualifier';

Line 1433: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type

1429: x_Msg_Data OUT NOCOPY VARCHAR2,
1430: p_Seed_Qual_Rec IN JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_SEED_QUAL_REC,
1431: p_Qual_Usgs_Rec IN JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type := JTF_QUALIFIER_PUB.G_MISS_QUAL_USGS_ALL_REC,
1432: x_Seed_Qual_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type,
1433: x_Qual_Usgs_Rec OUT NOCOPY JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type
1434: )
1435: IS
1436: l_api_name CONSTANT VARCHAR2(30) := 'Update_Qualifier';
1437: l_api_version CONSTANT NUMBER := 1.0;

Line 1441: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;

1437: l_api_version CONSTANT NUMBER := 1.0;
1438: l_return_status VARCHAR2(1);
1439:
1440: /* local scratch records */
1441: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1442: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1443:
1444: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1445: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;

Line 1442: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;

1438: l_return_status VARCHAR2(1);
1439:
1440: /* local scratch records */
1441: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1442: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1443:
1444: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1445: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1446:

Line 1444: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;

1440: /* local scratch records */
1441: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1442: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1443:
1444: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1445: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1446:
1447: BEGIN
1448:

Line 1445: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;

1441: l_seed_qual_rec JTF_QUALIFIER_PUB.Seed_Qual_Rec_Type;
1442: l_seed_qual_out_rec JTF_QUALIFIER_PUB.Seed_Qual_Out_Rec_Type;
1443:
1444: l_qual_usgs_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Rec_Type;
1445: l_qual_usgs_out_rec JTF_QUALIFIER_PUB.Qual_Usgs_All_Out_Rec_Type;
1446:
1447: BEGIN
1448:
1449: