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_CURRENCY_PVT dependencies on QP_GLOBALS

Line 12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

8: -- Curr_Lists
9:
10: PROCEDURE Curr_Lists
11: ( p_validation_level IN NUMBER
12: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
13: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
14: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
16: , x_old_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

Line 20: l_control_rec QP_GLOBALS.Control_Rec_Type;

16: , x_old_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;
21: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
22: l_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_old_CURR_LISTS_rec;
23:
24: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

Line 58: l_control_rec := QP_GLOBALS.Init_Control_Rec

54: -- Debugging statements only by Sunil
55: Debug Code */
56: -- Load API control record
57:
58: l_control_rec := QP_GLOBALS.Init_Control_Rec
59: ( p_operation => l_CURR_LISTS_rec.operation
60: , p_control_rec => p_control_rec
61: );
62: /* Debug Code

Line 95: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

91: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: -- Prepare record.
94:
95: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
96:
97: l_CURR_LISTS_rec.db_flag := FND_API.G_FALSE;
98:
99: -- Set missing old record elements to NULL.

Line 104: ELSIF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

100:
101: l_old_CURR_LISTS_rec :=
102: QP_Curr_Lists_Util.Convert_Miss_To_Null (l_old_CURR_LISTS_rec);
103:
104: ELSIF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
105: OR l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE
106: THEN
107:
108: l_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;

Line 105: OR l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE

101: l_old_CURR_LISTS_rec :=
102: QP_Curr_Lists_Util.Convert_Miss_To_Null (l_old_CURR_LISTS_rec);
103:
104: ELSIF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
105: OR l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE
106: THEN
107:
108: l_CURR_LISTS_rec.db_flag := FND_API.G_TRUE;
109:

Line 140: IF ( l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

136:
137: -- oe_debug_pub.add('Check Pint-2');
138: -- Attribute level validation.
139:
140: IF ( l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
141: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE
142: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
143: -- Above if statement added by Sunil Pandey in order to avoid header level validations
144: -- for detail record

Line 141: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE

137: -- oe_debug_pub.add('Check Pint-2');
138: -- Attribute level validation.
139:
140: IF ( l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
141: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE
142: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
143: -- Above if statement added by Sunil Pandey in order to avoid header level validations
144: -- for detail record
145: IF l_control_rec.default_attributes

Line 142: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

138: -- Attribute level validation.
139:
140: IF ( l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
141: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE
142: or l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
143: -- Above if statement added by Sunil Pandey in order to avoid header level validations
144: -- for detail record
145: IF l_control_rec.default_attributes
146: OR l_control_rec.change_attributes

Line 224: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

220: -- oe_debug_pub.add('Inside CURR_LISTS Just before calling QP_Validate_Curr_Lists L-Package');
221:
222: IF l_control_rec.validate_entity THEN
223:
224: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
225: -- Added by sunilpandey to prevent delete operation of details from Public package
226: FND_MESSAGE.SET_NAME('QP','QP_CAN_NOT_DELETE_CURR_HDR');
227: OE_MSG_PUB.Add;
228:

Line 273: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

269: -- Step 4. Write to DB
270:
271: IF l_control_rec.write_to_db THEN
272:
273: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
274:
275: QP_Curr_Lists_Util.Delete_Row
276: ( p_currency_header_id => l_CURR_LISTS_rec.currency_header_id
277: );

Line 287: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

283: l_CURR_LISTS_rec.last_update_date := SYSDATE;
284: l_CURR_LISTS_rec.last_updated_by := FND_GLOBAL.USER_ID;
285: l_CURR_LISTS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
286:
287: IF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
288:
289: -- oe_debug_pub.add('Calling QP_Curr_Lists_Util.Update_Row from CURR_LISTS package');
290: QP_Curr_Lists_Util.Update_Row (l_CURR_LISTS_rec);
291:

Line 292: ELSIF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

288:
289: -- oe_debug_pub.add('Calling QP_Curr_Lists_Util.Update_Row from CURR_LISTS package');
290: QP_Curr_Lists_Util.Update_Row (l_CURR_LISTS_rec);
291:
292: ELSIF l_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
293:
294: l_CURR_LISTS_rec.creation_date := SYSDATE;
295: l_CURR_LISTS_rec.created_by := FND_GLOBAL.USER_ID;
296:

Line 350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type

346: -- Curr_Detailss
347:
348: PROCEDURE Curr_Detailss
349: ( p_validation_level IN NUMBER
350: , p_control_rec IN QP_GLOBALS.Control_Rec_Type
351: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type
352: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type
353: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
354: , x_old_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

Line 358: l_control_rec QP_GLOBALS.Control_Rec_Type;

354: , x_old_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
355: )
356: IS
357: l_return_status VARCHAR2(1);
358: l_control_rec QP_GLOBALS.Control_Rec_Type;
359: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
361: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

Line 389: l_control_rec := QP_GLOBALS.Init_Control_Rec

385: END IF;
386:
387: -- Load API control record
388:
389: l_control_rec := QP_GLOBALS.Init_Control_Rec
390: ( p_operation => l_CURR_DETAILS_rec.operation
391: , p_control_rec => p_control_rec
392: );
393:

Line 427: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

423: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
424:
425: -- Prepare record.
426:
427: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
428:
429: l_CURR_DETAILS_rec.db_flag := FND_API.G_FALSE;
430:
431: -- Set missing old record elements to NULL.

Line 436: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

432:
433: l_old_CURR_DETAILS_rec :=
434: QP_Curr_Details_Util.Convert_Miss_To_Null (l_old_CURR_DETAILS_rec);
435:
436: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
437: OR l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE
438: THEN
439:
440: l_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;

Line 437: OR l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE

433: l_old_CURR_DETAILS_rec :=
434: QP_Curr_Details_Util.Convert_Miss_To_Null (l_old_CURR_DETAILS_rec);
435:
436: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
437: OR l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE
438: THEN
439:
440: l_CURR_DETAILS_rec.db_flag := FND_API.G_TRUE;
441:

Line 497: IF ( l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE

493: Debug Code */
494:
495: -- Attribute level validation.
496:
497: IF ( l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
498: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE
499: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
500: -- Above if statement added by Sunil Pandey in order to avoid header level validations
501: -- for detail record

Line 498: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE

494:
495: -- Attribute level validation.
496:
497: IF ( l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
498: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE
499: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
500: -- Above if statement added by Sunil Pandey in order to avoid header level validations
501: -- for detail record
502: IF l_control_rec.default_attributes

Line 499: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN

495: -- Attribute level validation.
496:
497: IF ( l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE
498: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE
499: or l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE ) THEN
500: -- Above if statement added by Sunil Pandey in order to avoid header level validations
501: -- for detail record
502: IF l_control_rec.default_attributes
503: OR l_control_rec.change_attributes

Line 682: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

678: -- oe_debug_pub.add('** BEFORE Calling QP_Validate_Curr_Details package; OUTSIDE IF');
679: IF l_control_rec.validate_entity THEN
680: -- oe_debug_pub.add('** BEFORE Calling QP_Validate_Curr_Details package; INSIDE FIRST IF');
681:
682: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
683:
684: -- Added by sunilpandey to prevent delete operation of details from Public package
685: FND_MESSAGE.SET_NAME('QP','QP_CAN_NOT_DELETE_CURR_DTL');
686: OE_MSG_PUB.Add;

Line 734: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN

730: Debug Code */
731:
732: IF l_control_rec.write_to_db THEN
733:
734: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_DELETE THEN
735:
736: -- oe_debug_pub.add('QP_Curr_Details_Util.Delete_Row is being called');
737: QP_Curr_Details_Util.Delete_Row
738: ( p_currency_detail_id => l_CURR_DETAILS_rec.currency_detail_id

Line 750: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN

746: l_CURR_DETAILS_rec.last_update_date := SYSDATE;
747: l_CURR_DETAILS_rec.last_updated_by := FND_GLOBAL.USER_ID;
748: l_CURR_DETAILS_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
749:
750: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
751:
752: QP_Curr_Details_Util.Update_Row (l_CURR_DETAILS_rec);
753:
754: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 754: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

750: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
751:
752: QP_Curr_Details_Util.Update_Row (l_CURR_DETAILS_rec);
753:
754: ELSIF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
755:
756: l_CURR_DETAILS_rec.creation_date := SYSDATE;
757: l_CURR_DETAILS_rec.created_by := FND_GLOBAL.USER_ID;
758:

Line 864: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=

860: ( p_api_version_number IN NUMBER
861: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
862: , p_commit IN VARCHAR2 := FND_API.G_FALSE
863: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
864: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
865: QP_GLOBALS.G_MISS_CONTROL_REC
866: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
867: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
868: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 865: QP_GLOBALS.G_MISS_CONTROL_REC

861: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
862: , p_commit IN VARCHAR2 := FND_API.G_FALSE
863: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
864: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
865: QP_GLOBALS.G_MISS_CONTROL_REC
866: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
867: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
868: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
869: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

Line 884: l_control_rec QP_GLOBALS.Control_Rec_Type;

880: IS
881: l_api_version_number CONSTANT NUMBER := 1.0;
882: l_api_name CONSTANT VARCHAR2(30):= 'Process_Currency';
883: l_return_status VARCHAR2(1);
884: l_control_rec QP_GLOBALS.Control_Rec_Type;
885: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
886: l_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_old_CURR_LISTS_rec;
887: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
888: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

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

945:
946: -- Perform CURR_LISTS group requests.
947:
948: IF p_control_rec.process AND
949: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
950: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_LISTS)
951: THEN
952:
953: NULL;

Line 950: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_LISTS)

946: -- Perform CURR_LISTS group requests.
947:
948: IF p_control_rec.process AND
949: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
950: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_LISTS)
951: THEN
952:
953: NULL;
954:

Line 963: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE

959: FOR I IN 1..l_CURR_DETAILS_tbl.COUNT LOOP
960:
961: l_CURR_DETAILS_rec := l_CURR_DETAILS_tbl(I);
962:
963: IF l_CURR_DETAILS_rec.operation = QP_GLOBALS.G_OPR_CREATE
964: AND (l_CURR_DETAILS_rec.currency_header_id IS NULL OR
965: l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM)
966: THEN
967:

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

988:
989: -- Perform CURR_DETAILS group requests.
990:
991: IF p_control_rec.process AND
992: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
993: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_DETAILS)
994: THEN
995:
996: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 993: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_DETAILS)

989: -- Perform CURR_DETAILS group requests.
990:
991: IF p_control_rec.process AND
992: (p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL OR
993: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_DETAILS)
994: THEN
995:
996: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
997: (p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS

Line 997: (p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS

993: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_CURR_DETAILS)
994: THEN
995:
996: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
997: (p_entity_code => QP_GLOBALS.G_ENTITY_CURR_DETAILS
998: ,p_delete => FND_API.G_TRUE
999: ,x_return_status => l_return_status
1000: );
1001: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1012: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL

1008:
1009: -- Step 6. Perform Object group logic
1010:
1011: IF p_control_rec.process AND
1012: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
1013: THEN
1014:
1015: NULL;
1016:

Line 1171: IF p_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN

1167: -- Lock CURR_LISTS
1168:
1169: -- oe_debug_pub.add('Inside QPXFCURB Lock_Row; p_CURR_LISTS_rec.operation: '||p_CURR_LISTS_rec.operation);
1170:
1171: IF p_CURR_LISTS_rec.operation = QP_GLOBALS.G_OPR_LOCK THEN
1172:
1173: QP_Curr_Lists_Util.Lock_Row
1174: ( p_CURR_LISTS_rec => p_CURR_LISTS_rec
1175: , x_CURR_LISTS_rec => x_CURR_LISTS_rec

Line 1192: IF p_CURR_DETAILS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN

1188: -- Lock CURR_DETAILS
1189:
1190: FOR I IN 1..p_CURR_DETAILS_tbl.COUNT LOOP
1191:
1192: IF p_CURR_DETAILS_tbl(I).operation = QP_GLOBALS.G_OPR_LOCK THEN
1193:
1194: QP_Curr_Details_Util.Lock_Row
1195: ( p_CURR_DETAILS_rec => p_CURR_DETAILS_tbl(I)
1196: , x_CURR_DETAILS_rec => l_CURR_DETAILS_rec