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.QP_ATTR_MAP_PVT dependencies on QP_GLOBALS

Line 12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

8: -- Pte
9:
10: PROCEDURE Pte
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
14: , p_old_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type
15: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type

Line 20: l_control_rec QP_GLOBALS.Control_Rec_Type;

16: , x_old_PTE_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Pte_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
22: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
23: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
24: BEGIN

Line 28: l_control_rec := QP_GLOBALS.Init_Control_Rec

24: BEGIN
25:
26: -- Load API control record
27:
28: l_control_rec := QP_GLOBALS.Init_Control_Rec
29: ( p_operation => l_PTE_rec.operation
30: , p_control_rec => p_control_rec
31: );
32:

Line 39: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

35: l_PTE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: -- Prepare record.
38:
39: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
40:
41: l_PTE_rec.db_flag := FND_API.G_FALSE;
42:
43: -- Set missing old record elements to NULL.

Line 48: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE

44:
45: l_old_PTE_rec :=
46: QP_Pte_Util.Convert_Miss_To_Null (l_old_PTE_rec);
47:
48: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
49: OR l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE
50: THEN
51:
52: l_PTE_rec.db_flag := FND_API.G_TRUE;

Line 49: OR l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE

45: l_old_PTE_rec :=
46: QP_Pte_Util.Convert_Miss_To_Null (l_old_PTE_rec);
47:
48: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
49: OR l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE
50: THEN
51:
52: l_PTE_rec.db_flag := FND_API.G_TRUE;
53:

Line 148: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

144: -- Entity level validation.
145:
146: IF l_control_rec.validate_entity THEN
147:
148: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
149:
150: QP_Validate_Pte.Entity_Delete
151: ( x_return_status => l_return_status
152: , p_PTE_rec => l_PTE_rec

Line 177: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

173: -- Step 4. Write to DB
174:
175: IF l_control_rec.write_to_db THEN
176:
177: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
178:
179: QP_Pte_Util.Delete_Row
180: ( p_lookup_code => l_PTE_rec.lookup_code
181: );

Line 191: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

187: --**l_PTE_rec.last_update_date := SYSDATE;
188: --**l_PTE_rec.last_updated_by := FND_GLOBAL.USER_ID;
189: --**l_PTE_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
190:
191: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
192:
193: QP_Pte_Util.Update_Row (l_PTE_rec);
194:
195: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 195: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

191: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
192:
193: QP_Pte_Util.Update_Row (l_PTE_rec);
194:
195: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
196:
197: --**l_PTE_rec.creation_date := SYSDATE;
198: --**l_PTE_rec.created_by := FND_GLOBAL.USER_ID;
199:

Line 252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

248: -- Rqts
249:
250: PROCEDURE Rqts
251: ( p_validation_level IN NUMBER
252: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
253: , p_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
254: , p_old_RQT_tbl IN QP_Attr_Map_PUB.Rqt_Tbl_Type
255: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type

Line 260: l_control_rec QP_GLOBALS.Control_Rec_Type;

256: , x_old_RQT_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Rqt_Tbl_Type
257: )
258: IS
259: l_return_status VARCHAR2(1);
260: l_control_rec QP_GLOBALS.Control_Rec_Type;
261: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
262: l_p_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
263: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
264: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 288: l_control_rec := QP_GLOBALS.Init_Control_Rec

284: END IF;
285:
286: -- Load API control record
287:
288: l_control_rec := QP_GLOBALS.Init_Control_Rec
289: ( p_operation => l_RQT_rec.operation
290: , p_control_rec => p_control_rec
291: );
292:

Line 299: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

295: l_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: -- Prepare record.
298:
299: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
300:
301: l_RQT_rec.db_flag := FND_API.G_FALSE;
302:
303: -- Set missing old record elements to NULL.

Line 308: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE

304:
305: l_old_RQT_rec :=
306: QP_Rqt_Util.Convert_Miss_To_Null (l_old_RQT_rec);
307:
308: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE
309: OR l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE
310: THEN
311:
312: l_RQT_rec.db_flag := FND_API.G_TRUE;

Line 309: OR l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE

305: l_old_RQT_rec :=
306: QP_Rqt_Util.Convert_Miss_To_Null (l_old_RQT_rec);
307:
308: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE
309: OR l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE
310: THEN
311:
312: l_RQT_rec.db_flag := FND_API.G_TRUE;
313:

Line 409: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

405: -- Entity level validation.
406:
407: IF l_control_rec.validate_entity THEN
408:
409: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
410:
411: QP_Validate_Rqt.Entity_Delete
412: ( x_return_status => l_return_status
413: , p_RQT_rec => l_RQT_rec

Line 438: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

434: -- Step 4. Write to DB
435:
436: IF l_control_rec.write_to_db THEN
437:
438: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
439:
440: QP_Rqt_Util.Delete_Row
441: ( p_request_type_code => l_RQT_rec.request_type_code
442: );

Line 452: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

448: l_RQT_rec.last_update_date := SYSDATE;
449: l_RQT_rec.last_updated_by := FND_GLOBAL.USER_ID;
450: l_RQT_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
451:
452: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
453:
454: QP_Rqt_Util.Update_Row (l_RQT_rec);
455:
456: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 456: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

452: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
453:
454: QP_Rqt_Util.Update_Row (l_RQT_rec);
455:
456: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
457:
458: l_RQT_rec.creation_date := SYSDATE;
459: l_RQT_rec.created_by := FND_GLOBAL.USER_ID;
460:

Line 546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

542: -- Sscs
543:
544: PROCEDURE Sscs
545: ( p_validation_level IN NUMBER
546: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
547: , p_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
548: , p_old_SSC_tbl IN QP_Attr_Map_PUB.Ssc_Tbl_Type
549: , x_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type

Line 554: l_control_rec QP_GLOBALS.Control_Rec_Type;

550: , x_old_SSC_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Ssc_Tbl_Type
551: )
552: IS
553: l_return_status VARCHAR2(1);
554: l_control_rec QP_GLOBALS.Control_Rec_Type;
555: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
556: l_p_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
557: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
558: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 582: l_control_rec := QP_GLOBALS.Init_Control_Rec

578: END IF;
579:
580: -- Load API control record
581:
582: l_control_rec := QP_GLOBALS.Init_Control_Rec
583: ( p_operation => l_SSC_rec.operation
584: , p_control_rec => p_control_rec
585: );
586:

Line 593: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

589: l_SSC_rec.return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: -- Prepare record.
592:
593: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
594:
595: l_SSC_rec.db_flag := FND_API.G_FALSE;
596:
597: -- Set missing old record elements to NULL.

Line 602: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE

598:
599: l_old_SSC_rec :=
600: QP_Ssc_Util.Convert_Miss_To_Null (l_old_SSC_rec);
601:
602: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE
603: OR l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE
604: THEN
605:
606: l_SSC_rec.db_flag := FND_API.G_TRUE;

Line 603: OR l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE

599: l_old_SSC_rec :=
600: QP_Ssc_Util.Convert_Miss_To_Null (l_old_SSC_rec);
601:
602: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE
603: OR l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE
604: THEN
605:
606: l_SSC_rec.db_flag := FND_API.G_TRUE;
607:

Line 702: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

698: -- Entity level validation.
699:
700: IF l_control_rec.validate_entity THEN
701:
702: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
703:
704: QP_Validate_Ssc.Entity_Delete
705: ( x_return_status => l_return_status
706: , p_SSC_rec => l_SSC_rec

Line 731: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

727: -- Step 4. Write to DB
728:
729: IF l_control_rec.write_to_db THEN
730:
731: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
732:
733: QP_Ssc_Util.Delete_Row
734: ( p_pte_source_system_id => l_SSC_rec.pte_source_system_id
735: );

Line 745: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

741: l_SSC_rec.last_update_date := SYSDATE;
742: l_SSC_rec.last_updated_by := FND_GLOBAL.USER_ID;
743: l_SSC_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
744:
745: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
746:
747: QP_Ssc_Util.Update_Row (l_SSC_rec);
748:
749: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 749: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

745: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
746:
747: QP_Ssc_Util.Update_Row (l_SSC_rec);
748:
749: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
750:
751: l_SSC_rec.creation_date := SYSDATE;
752: l_SSC_rec.created_by := FND_GLOBAL.USER_ID;
753:

Line 839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

835: -- Psgs
836:
837: PROCEDURE Psgs
838: ( p_validation_level IN NUMBER
839: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
840: , p_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
841: , p_old_PSG_tbl IN QP_Attr_Map_PUB.Psg_Tbl_Type
842: , x_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type

Line 847: l_control_rec QP_GLOBALS.Control_Rec_Type;

843: , x_old_PSG_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_Tbl_Type
844: )
845: IS
846: l_return_status VARCHAR2(1);
847: l_control_rec QP_GLOBALS.Control_Rec_Type;
848: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
849: l_p_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
850: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
851: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 875: l_control_rec := QP_GLOBALS.Init_Control_Rec

871: END IF;
872:
873: -- Load API control record
874:
875: l_control_rec := QP_GLOBALS.Init_Control_Rec
876: ( p_operation => l_PSG_rec.operation
877: , p_control_rec => p_control_rec
878: );
879:

Line 886: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

882: l_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: -- Prepare record.
885:
886: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
887:
888: l_PSG_rec.db_flag := FND_API.G_FALSE;
889:
890: -- Set missing old record elements to NULL.

Line 895: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE

891:
892: l_old_PSG_rec :=
893: QP_Psg_Util.Convert_Miss_To_Null (l_old_PSG_rec);
894:
895: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
896: OR l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE
897: THEN
898:
899: l_PSG_rec.db_flag := FND_API.G_TRUE;

Line 896: OR l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE

892: l_old_PSG_rec :=
893: QP_Psg_Util.Convert_Miss_To_Null (l_old_PSG_rec);
894:
895: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
896: OR l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE
897: THEN
898:
899: l_PSG_rec.db_flag := FND_API.G_TRUE;
900:

Line 995: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

991: -- Entity level validation.
992:
993: IF l_control_rec.validate_entity THEN
994:
995: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
996:
997: QP_Validate_Psg.Entity_Delete
998: ( x_return_status => l_return_status
999: , p_PSG_rec => l_PSG_rec

Line 1024: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1020: -- Step 4. Write to DB
1021:
1022: IF l_control_rec.write_to_db THEN
1023:
1024: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1025:
1026: QP_Psg_Util.Delete_Row
1027: ( p_segment_pte_id => l_PSG_rec.segment_pte_id
1028: );

Line 1038: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1034: l_PSG_rec.last_update_date := SYSDATE;
1035: l_PSG_rec.last_updated_by := FND_GLOBAL.USER_ID;
1036: l_PSG_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1037:
1038: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1039:
1040: QP_Psg_Util.Update_Row (l_PSG_rec);
1041:
1042: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1042: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1038: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1039:
1040: QP_Psg_Util.Update_Row (l_PSG_rec);
1041:
1042: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1043:
1044: l_PSG_rec.creation_date := SYSDATE;
1045: l_PSG_rec.created_by := FND_GLOBAL.USER_ID;
1046:

Line 1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1128: -- Sous
1129:
1130: PROCEDURE Sous
1131: ( p_validation_level IN NUMBER
1132: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1133: , p_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1134: , p_old_SOU_tbl IN QP_Attr_Map_PUB.Sou_Tbl_Type
1135: , x_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type

Line 1140: l_control_rec QP_GLOBALS.Control_Rec_Type;

1136: , x_old_SOU_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Tbl_Type
1137: )
1138: IS
1139: l_return_status VARCHAR2(1);
1140: l_control_rec QP_GLOBALS.Control_Rec_Type;
1141: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1142: l_p_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1143: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1144: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1168: l_control_rec := QP_GLOBALS.Init_Control_Rec

1164: END IF;
1165:
1166: -- Load API control record
1167:
1168: l_control_rec := QP_GLOBALS.Init_Control_Rec
1169: ( p_operation => l_SOU_rec.operation
1170: , p_control_rec => p_control_rec
1171: );
1172:

Line 1179: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1175: l_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1176:
1177: -- Prepare record.
1178:
1179: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1180:
1181: l_SOU_rec.db_flag := FND_API.G_FALSE;
1182:
1183: -- Set missing old record elements to NULL.

Line 1188: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1184:
1185: l_old_SOU_rec :=
1186: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);
1187:
1188: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1189: OR l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE
1190: THEN
1191:
1192: l_SOU_rec.db_flag := FND_API.G_TRUE;

Line 1189: OR l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE

1185: l_old_SOU_rec :=
1186: QP_Sou_Util.Convert_Miss_To_Null (l_old_SOU_rec);
1187:
1188: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1189: OR l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE
1190: THEN
1191:
1192: l_SOU_rec.db_flag := FND_API.G_TRUE;
1193:

Line 1289: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1285: -- Entity level validation.
1286:
1287: IF l_control_rec.validate_entity THEN
1288:
1289: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1290:
1291: QP_Validate_Sou.Entity_Delete
1292: ( x_return_status => l_return_status
1293: , p_SOU_rec => l_SOU_rec

Line 1318: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1314: -- Step 4. Write to DB
1315:
1316: IF l_control_rec.write_to_db THEN
1317:
1318: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1319:
1320: QP_Sou_Util.Delete_Row
1321: ( p_attribute_sourcing_id => l_SOU_rec.attribute_sourcing_id
1322: );

Line 1332: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1328: l_SOU_rec.last_update_date := SYSDATE;
1329: l_SOU_rec.last_updated_by := FND_GLOBAL.USER_ID;
1330: l_SOU_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1331:
1332: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1333:
1334: QP_Sou_Util.Update_Row (l_SOU_rec);
1335:
1336: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1336: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1332: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1333:
1334: QP_Sou_Util.Update_Row (l_SOU_rec);
1335:
1336: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1337:
1338: l_SOU_rec.creation_date := SYSDATE;
1339: l_SOU_rec.created_by := FND_GLOBAL.USER_ID;
1340:

Line 1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

1422: -- Fnas
1423:
1424: PROCEDURE Fnas
1425: ( p_validation_level IN NUMBER
1426: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
1427: , p_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1428: , p_old_FNA_tbl IN QP_Attr_Map_PUB.Fna_Tbl_Type
1429: , x_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type

Line 1434: l_control_rec QP_GLOBALS.Control_Rec_Type;

1430: , x_old_FNA_tbl OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Fna_Tbl_Type
1431: )
1432: IS
1433: l_return_status VARCHAR2(1);
1434: l_control_rec QP_GLOBALS.Control_Rec_Type;
1435: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1436: l_p_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1437: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1438: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1462: l_control_rec := QP_GLOBALS.Init_Control_Rec

1458: END IF;
1459:
1460: -- Load API control record
1461:
1462: l_control_rec := QP_GLOBALS.Init_Control_Rec
1463: ( p_operation => l_FNA_rec.operation
1464: , p_control_rec => p_control_rec
1465: );
1466:

Line 1473: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1469: l_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1470:
1471: -- Prepare record.
1472:
1473: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1474:
1475: l_FNA_rec.db_flag := FND_API.G_FALSE;
1476:
1477: -- Set missing old record elements to NULL.

Line 1482: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE

1478:
1479: l_old_FNA_rec :=
1480: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);
1481:
1482: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1483: OR l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE
1484: THEN
1485:
1486: l_FNA_rec.db_flag := FND_API.G_TRUE;

Line 1483: OR l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE

1479: l_old_FNA_rec :=
1480: QP_Fna_Util.Convert_Miss_To_Null (l_old_FNA_rec);
1481:
1482: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1483: OR l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE
1484: THEN
1485:
1486: l_FNA_rec.db_flag := FND_API.G_TRUE;
1487:

Line 1581: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1577: -- Entity level validation.
1578:
1579: IF l_control_rec.validate_entity THEN
1580:
1581: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1582:
1583: QP_Validate_Fna.Entity_Delete
1584: ( x_return_status => l_return_status
1585: , p_FNA_rec => l_FNA_rec

Line 1610: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

1606: -- Step 4. Write to DB
1607:
1608: IF l_control_rec.write_to_db THEN
1609:
1610: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
1611:
1612: QP_Fna_Util.Delete_Row
1613: ( p_pte_sourcesystem_fnarea_id => l_FNA_rec.pte_sourcesystem_fnarea_id
1614: );

Line 1617: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

1613: ( p_pte_sourcesystem_fnarea_id => l_FNA_rec.pte_sourcesystem_fnarea_id
1614: );
1615:
1616: qp_delayed_requests_PVT.log_request(
1617: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1618: p_entity_id => l_FNA_rec.pte_source_system_id,
1619: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
1620: p_requesting_entity_id => l_FNA_rec.pte_source_system_id,
1621: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,

Line 1619: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,

1615:
1616: qp_delayed_requests_PVT.log_request(
1617: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1618: p_entity_id => l_FNA_rec.pte_source_system_id,
1619: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
1620: p_requesting_entity_id => l_FNA_rec.pte_source_system_id,
1621: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,
1622: x_return_status => l_dummy_ret_status);
1623:

Line 1621: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,

1617: p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1618: p_entity_id => l_FNA_rec.pte_source_system_id,
1619: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_FNA,
1620: p_requesting_entity_id => l_FNA_rec.pte_source_system_id,
1621: p_request_type => QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS,
1622: x_return_status => l_dummy_ret_status);
1623:
1624: IF l_control_rec.called_from_ui = 'N' THEN
1625: QP_Fna_Util.Warn_Disable_Delete_Fna

Line 1641: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

1637: l_FNA_rec.last_update_date := SYSDATE;
1638: l_FNA_rec.last_updated_by := FND_GLOBAL.USER_ID;
1639: l_FNA_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1640:
1641: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1642:
1643: QP_Fna_Util.Update_Row (l_FNA_rec);
1644:
1645: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1645: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

1641: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
1642:
1643: QP_Fna_Util.Update_Row (l_FNA_rec);
1644:
1645: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1646:
1647: l_FNA_rec.creation_date := SYSDATE;
1648: l_FNA_rec.created_by := FND_GLOBAL.USER_ID;
1649:

Line 1710: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

1706: WHEN FND_API.G_EXC_ERROR THEN
1707:
1708: if l_control_rec.called_from_ui = 'N' then
1709: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1710: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1711: p_entity_id => l_FNA_rec.pte_source_system_id,
1712: x_return_status => l_return_status );
1713: end if;
1714:

Line 1722: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

1718:
1719:
1720: if l_control_rec.called_from_ui = 'N' then
1721: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1722: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1723: p_entity_id => l_FNA_rec.pte_source_system_id,
1724: x_return_status => l_return_status );
1725: end if;
1726:

Line 1742: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

1738:
1739:
1740: if l_control_rec.called_from_ui = 'N' then
1741: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1742: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,
1743: p_entity_id => l_FNA_rec.pte_source_system_id,
1744: x_return_status => l_return_status );
1745: end if;
1746:

Line 1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

1768: ( p_api_version_number IN NUMBER
1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1773: QP_GLOBALS.G_MISS_CONTROL_REC
1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1773: QP_GLOBALS.G_MISS_CONTROL_REC

1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1773: QP_GLOBALS.G_MISS_CONTROL_REC
1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1776: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1777: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

Line 1812: l_control_rec QP_GLOBALS.Control_Rec_Type;

1808: IS
1809: l_api_version_number CONSTANT NUMBER := 1.0;
1810: l_api_name CONSTANT VARCHAR2(30):= 'Process_Attr_Mapping';
1811: l_return_status VARCHAR2(1);
1812: l_control_rec QP_GLOBALS.Control_Rec_Type;
1813: l_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1814: l_p_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_PTE_rec;
1815: l_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;
1816: l_p_old_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type := p_old_PTE_rec;

Line 1908: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

1904:
1905: -- Perform PTE group requests.
1906:
1907: IF p_control_rec.process AND
1908: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1909: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PTE)
1910: THEN
1911:
1912: NULL;

Line 1909: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PTE)

1905: -- Perform PTE group requests.
1906:
1907: IF p_control_rec.process AND
1908: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1909: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PTE)
1910: THEN
1911:
1912: NULL;
1913:

Line 1922: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE

1918: FOR I IN 1..l_RQT_tbl.COUNT LOOP
1919:
1920: l_RQT_rec := l_RQT_tbl(I);
1921:
1922: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE
1923: --**AND (l_RQT_rec.lookup_code IS NULL OR
1924: AND (l_RQT_rec.pte_code IS NULL OR
1925: --** l_RQT_rec.lookup_code = FND_API.G_MISS_CHAR)
1926: l_RQT_rec.pte_code = FND_API.G_MISS_CHAR)

Line 1951: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

1947:
1948: -- Perform RQT group requests.
1949:
1950: IF p_control_rec.process AND
1951: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1952: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_RQT)
1953: THEN
1954:
1955: NULL;

Line 1952: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_RQT)

1948: -- Perform RQT group requests.
1949:
1950: IF p_control_rec.process AND
1951: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1952: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_RQT)
1953: THEN
1954:
1955: NULL;
1956:

Line 1965: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE

1961: FOR I IN 1..l_SSC_tbl.COUNT LOOP
1962:
1963: l_SSC_rec := l_SSC_tbl(I);
1964:
1965: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE
1966: --**AND (l_SSC_rec.lookup_code IS NULL OR
1967: AND (l_SSC_rec.pte_code IS NULL OR
1968: --**l_SSC_rec.lookup_code = FND_API.G_MISS_CHAR)
1969: l_SSC_rec.pte_code = FND_API.G_MISS_CHAR)

Line 1994: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

1990:
1991: -- Perform SSC group requests.
1992:
1993: IF p_control_rec.process AND
1994: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1995: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SSC)
1996: THEN
1997:
1998: NULL;

Line 1995: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SSC)

1991: -- Perform SSC group requests.
1992:
1993: IF p_control_rec.process AND
1994: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
1995: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SSC)
1996: THEN
1997:
1998: NULL;
1999:

Line 2008: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE

2004: FOR I IN 1..l_PSG_tbl.COUNT LOOP
2005:
2006: l_PSG_rec := l_PSG_tbl(I);
2007:
2008: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE
2009: --**AND (l_PSG_rec.lookup_code IS NULL OR
2010: AND (l_PSG_rec.pte_code IS NULL OR
2011: --**l_PSG_rec.lookup_code = FND_API.G_MISS_CHAR)
2012: l_PSG_rec.pte_code = FND_API.G_MISS_CHAR)

Line 2038: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2034: -- Perform PSG group requests.
2035: --dbms_output.put_line('in qp_qttr_mapping_pvt 1 ............................');
2036:
2037: IF p_control_rec.process AND
2038: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2039: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PSG)
2040: THEN
2041:
2042: NULL;

Line 2039: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PSG)

2035: --dbms_output.put_line('in qp_qttr_mapping_pvt 1 ............................');
2036:
2037: IF p_control_rec.process AND
2038: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2039: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PSG)
2040: THEN
2041:
2042: NULL;
2043:

Line 2055: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE

2051:
2052: l_SOU_rec := l_SOU_tbl(I);
2053:
2054: --dbms_output.put_line('in qp_qttr_mapping_pvt 21 ............................');
2055: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE
2056: --**AND (l_SOU_rec.segment_pte_id IS NULL OR
2057: AND (l_SOU_rec.segment_id IS NULL OR
2058: --**l_SOU_rec.segment_pte_id = FND_API.G_MISS_NUM)
2059: l_SOU_rec.segment_id = FND_API.G_MISS_NUM)

Line 2114: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2110:
2111: -- Perform SOU group requests.
2112:
2113: IF p_control_rec.process AND
2114: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2115: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SOU)
2116: THEN
2117:
2118: NULL;

Line 2115: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SOU)

2111: -- Perform SOU group requests.
2112:
2113: IF p_control_rec.process AND
2114: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2115: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_SOU)
2116: THEN
2117:
2118: NULL;
2119:

Line 2127: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE

2123: FOR I IN 1..l_FNA_tbl.COUNT LOOP
2124:
2125: l_FNA_rec := l_FNA_tbl(I);
2126:
2127: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE
2128: AND (l_FNA_rec.pte_source_system_id IS NULL OR
2129: l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM)
2130: THEN
2131:

Line 2154: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR

2150:
2151: -- Perform FNA group requests.
2152:
2153: IF p_control_rec.process AND
2154: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2155: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_FNA)
2156: THEN
2157:
2158: NULL;

Line 2155: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_FNA)

2151: -- Perform FNA group requests.
2152:
2153: IF p_control_rec.process AND
2154: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
2155: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_FNA)
2156: THEN
2157:
2158: NULL;
2159:

Line 2165: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

2161:
2162: -- Step 6. Perform Object group logic
2163:
2164: IF p_control_rec.process AND
2165: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2166: THEN
2167:
2168: NULL;
2169:

Line 2389: IF p_PTE_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

2385: SAVEPOINT Lock_Attr_Mapping_PVT;
2386:
2387: -- Lock PTE
2388:
2389: IF p_PTE_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
2390:
2391: QP_Pte_Util.Lock_Row
2392: ( p_PTE_rec => p_PTE_rec
2393: , x_PTE_rec => x_PTE_rec

Line 2410: IF p_RQT_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2406: -- Lock RQT
2407:
2408: FOR I IN 1..p_RQT_tbl.COUNT LOOP
2409:
2410: IF p_RQT_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2411:
2412: QP_Rqt_Util.Lock_Row
2413: ( p_RQT_rec => p_RQT_tbl(I)
2414: , x_RQT_rec => l_RQT_rec

Line 2434: IF p_SSC_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2430: -- Lock SSC
2431:
2432: FOR I IN 1..p_SSC_tbl.COUNT LOOP
2433:
2434: IF p_SSC_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2435:
2436: QP_Ssc_Util.Lock_Row
2437: ( p_SSC_rec => p_SSC_tbl(I)
2438: , x_SSC_rec => l_SSC_rec

Line 2458: IF p_PSG_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2454: -- Lock PSG
2455:
2456: FOR I IN 1..p_PSG_tbl.COUNT LOOP
2457:
2458: IF p_PSG_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2459:
2460: QP_Psg_Util.Lock_Row
2461: ( p_PSG_rec => p_PSG_tbl(I)
2462: , x_PSG_rec => l_PSG_rec

Line 2482: IF p_SOU_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2478: -- Lock SOU
2479:
2480: FOR I IN 1..p_SOU_tbl.COUNT LOOP
2481:
2482: IF p_SOU_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2483:
2484: QP_Sou_Util.Lock_Row
2485: ( p_SOU_rec => p_SOU_tbl(I)
2486: , x_SOU_rec => l_SOU_rec

Line 2506: IF p_FNA_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

2502: -- Lock FNA
2503:
2504: FOR I IN 1..p_FNA_tbl.COUNT LOOP
2505:
2506: IF p_FNA_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
2507:
2508: QP_Fna_Util.Lock_Row
2509: ( p_FNA_rec => p_FNA_tbl(I)
2510: , x_FNA_rec => l_FNA_rec

Line 2816: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA

2812: BEGIN
2813:
2814: -- Execute FNA delayed request to check for enabled functional areas
2815: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2816: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA
2817: ,p_delete => FND_API.G_TRUE
2818: ,x_return_status => x_return_status
2819: );
2820: