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_CURRENCY_PUB

Line 13: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

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
17: )

Line 14: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type

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
17: )
18: IS

Line 15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);

Line 16: , x_old_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

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
17: )
18: IS
19: l_return_status VARCHAR2(1);
20: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 21: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;

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]
25:

Line 22: l_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_old_CURR_LISTS_rec;

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]
25:
26: BEGIN

Line 24: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

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]
25:
26: BEGIN
27:
28: /* Debug Code

Line 351: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type

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
355: )

Line 352: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type

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
355: )
356: IS

Line 353: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

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
355: )
356: IS
357: l_return_status VARCHAR2(1);

Line 354: , x_old_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

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
355: )
356: IS
357: l_return_status VARCHAR2(1);
358: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 359: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_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;
363:

Line 360: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

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;
363:
364: l_p_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type; --[prarasto]

Line 361: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

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;
363:
364: l_p_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type; --[prarasto]
365:

Line 362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

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;
363:
364: l_p_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type; --[prarasto]
365:
366: BEGIN

Line 364: l_p_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type; --[prarasto]

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;
363:
364: l_p_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type; --[prarasto]
365:
366: BEGIN
367: -- oe_debug_pub.add('Entered curr_detailss');
368:

Line 384: l_old_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;

380:
381: IF l_old_CURR_DETAILS_tbl.EXISTS(I) THEN
382: l_old_CURR_DETAILS_rec := l_old_CURR_DETAILS_tbl(I);
383: ELSE
384: l_old_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;
385: END IF;
386:
387: -- Load API control record
388:

Line 869: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_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 :=
870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=

Line 870: QP_Currency_PUB.G_MISS_CURR_LISTS_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 :=
870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL

Line 871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

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 :=
870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=

Line 872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC

868: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
869: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL

Line 873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=

869: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

Line 874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL

870: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

Line 875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=

871: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
879: )

Line 876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL

872: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
879: )
880: IS

Line 877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

873: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
879: )
880: IS
881: l_api_version_number CONSTANT NUMBER := 1.0;

Line 878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

874: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
875: , p_old_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
876: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
877: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
878: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
879: )
880: IS
881: l_api_version_number CONSTANT NUMBER := 1.0;
882: l_api_name CONSTANT VARCHAR2(30):= 'Process_Currency';

Line 885: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;

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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 886: l_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_old_CURR_LISTS_rec;

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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

Line 887: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:

Line 888: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

Line 889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

Line 890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

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;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]

Line 892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

888: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
895: l_p_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
896:

Line 893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]

889: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
895: l_p_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
896:
897: BEGIN

Line 894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]

890: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
895: l_p_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
896:
897: BEGIN
898:

Line 895: l_p_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]

891:
892: l_p_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
893: l_p_old_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type; --[prarasto]
894: l_p_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
895: l_p_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type; --[prarasto]
896:
897: BEGIN
898:
899: -- oe_debug_pub.add('@#@#@Inside Process_Currency V');

Line 1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=

1127: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1128: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1129: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1130: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

Line 1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC

1128: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1129: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1130: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

Line 1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=

1129: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1130: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1137: )

Line 1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL

1130: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1137: )
1138: IS

Line 1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

1131: , p_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1137: )
1138: IS
1139: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

1132: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
1133: , p_CURR_DETAILS_tbl IN QP_Currency_PUB.Curr_Details_Tbl_Type :=
1134: QP_Currency_PUB.G_MISS_CURR_DETAILS_TBL
1135: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1136: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1137: )
1138: IS
1139: l_api_version_number CONSTANT NUMBER := 1.0;
1140: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Currency';

Line 1142: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1138: IS
1139: l_api_version_number CONSTANT NUMBER := 1.0;
1140: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Currency';
1141: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1142: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1143: BEGIN
1144:
1145: -- Standard call to check for call compatibility
1146:

Line 1304: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type

1300: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1301: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1302: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1303: , p_currency_header_id IN NUMBER
1304: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1305: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1306: )
1307: IS
1308: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1305: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type

1301: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1302: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1303: , p_currency_header_id IN NUMBER
1304: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_Rec_Type
1305: , x_CURR_DETAILS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Tbl_Type
1306: )
1307: IS
1308: l_api_version_number CONSTANT NUMBER := 1.0;
1309: l_api_name CONSTANT VARCHAR2(30):= 'Get_Currency';

Line 1310: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1306: )
1307: IS
1308: l_api_version_number CONSTANT NUMBER := 1.0;
1309: l_api_name CONSTANT VARCHAR2(30):= 'Get_Currency';
1310: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1311: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1312: BEGIN
1313:
1314: -- Standard call to check for call compatibility

Line 1311: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1307: IS
1308: l_api_version_number CONSTANT NUMBER := 1.0;
1309: l_api_name CONSTANT VARCHAR2(30):= 'Get_Currency';
1310: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1311: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1312: BEGIN
1313:
1314: -- Standard call to check for call compatibility
1315: