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_QP_FORM_CURR_DETAILS dependencies on QP_CURRENCY_PUB

Line 10: g_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Curr_Details';
7:
8: -- Global variables holding cached record.
9:
10: g_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
11: g_db_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
11: g_db_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_CURR_DETAILS

Line 16: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_CURR_DETAILS
16: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_CURR_DETAILS

Line 24: RETURN QP_Currency_PUB.Curr_Details_Rec_Type;

20: FUNCTION Get_CURR_DETAILS
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_currency_detail_id IN NUMBER
23: )
24: RETURN QP_Currency_PUB.Curr_Details_Rec_Type;
25:
26: PROCEDURE Clear_CURR_DETAILS;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

26: PROCEDURE Clear_CURR_DETAILS;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 84: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

80: , x_curr_attribute_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81: , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
82: )
83: IS
84: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
85: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);

Line 85: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;

81: , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
82: )
83: IS
84: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
85: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);
89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

82: )
83: IS
84: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
85: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);
89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
90: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

85: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);
89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
90: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
91: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
92: BEGIN
93:

Line 90: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

86: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);
89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
90: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
91: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
92: BEGIN
93:
94: -- oe_debug_pub.add('Inside CDT-F Default_Attributes');

Line 91: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

87: l_control_rec QP_GLOBALS.Control_Rec_Type;
88: l_return_status VARCHAR2(1);
89: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
90: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
91: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
92: BEGIN
93:
94: -- oe_debug_pub.add('Inside CDT-F Default_Attributes');
95: -- Set control flags.

Line 358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

354: , x_curr_attribute_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
355: , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
356: )
357: IS
358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

Line 359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

355: , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
356: )
357: IS
358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;

356: )
357: IS
358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);

Line 361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

357: IS
358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);
365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

358: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
359: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
360: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);
365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
366: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

361: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);
365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
366: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
367: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
368: BEGIN
369:

Line 366: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

362: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);
365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
366: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
367: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
368: BEGIN
369:
370: -- oe_debug_pub.add('Inside CDT-F Change_Attribute');

Line 367: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

363: l_control_rec QP_GLOBALS.Control_Rec_Type;
364: l_return_status VARCHAR2(1);
365: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
366: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
367: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
368: BEGIN
369:
370: -- oe_debug_pub.add('Inside CDT-F Change_Attribute');
371: -- Set control flags.

Line 893: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

889: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
890: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
891: )
892: IS
893: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
894: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 894: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

890: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
891: )
892: IS
893: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
894: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);

Line 895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

891: )
892: IS
893: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
894: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);
899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

892: IS
893: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
894: l_old_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);
899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
900: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

895: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);
899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
900: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
901: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
902: BEGIN
903:

Line 900: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

896: l_old_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);
899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
900: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
901: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
902: BEGIN
903:
904: -- oe_debug_pub.add('Inside CDT-F Validate_And_Write');

Line 901: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

897: l_control_rec QP_GLOBALS.Control_Rec_Type;
898: l_return_status VARCHAR2(1);
899: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
900: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
901: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
902: BEGIN
903:
904: -- oe_debug_pub.add('Inside CDT-F Validate_And_Write');
905: -- Set control flags.

Line 1055: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1051: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1052: , p_currency_detail_id IN NUMBER
1053: )
1054: IS
1055: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1056: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1057: l_control_rec QP_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

Line 1056: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1052: , p_currency_detail_id IN NUMBER
1053: )
1054: IS
1055: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1056: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1057: l_control_rec QP_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1060: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

Line 1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1055: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1056: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1057: l_control_rec QP_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1060: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1061: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1062: BEGIN
1063:

Line 1060: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1056: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1057: l_control_rec QP_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1060: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1061: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1062: BEGIN
1063:
1064: -- Set control flags.

Line 1061: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1057: l_control_rec QP_GLOBALS.Control_Rec_Type;
1058: l_return_status VARCHAR2(1);
1059: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1060: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1061: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1062: BEGIN
1063:
1064: -- Set control flags.
1065:

Line 1187: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1183: )
1184: IS
1185: l_control_rec QP_GLOBALS.Control_Rec_Type;
1186: l_return_status VARCHAR2(1);
1187: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1188: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1189: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1190: BEGIN
1191:

Line 1188: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1184: IS
1185: l_control_rec QP_GLOBALS.Control_Rec_Type;
1186: l_return_status VARCHAR2(1);
1187: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1188: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1189: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1190: BEGIN
1191:
1192: -- Set control flags.

Line 1189: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1185: l_control_rec QP_GLOBALS.Control_Rec_Type;
1186: l_return_status VARCHAR2(1);
1187: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1188: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1189: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1190: BEGIN
1191:
1192: -- Set control flags.
1193:

Line 1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1337: , p_precedence IN NUMBER
1338: )
1339: IS
1340: l_return_status VARCHAR2(1);
1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

Line 1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1338: )
1339: IS
1340: l_return_status VARCHAR2(1);
1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1346: BEGIN

Line 1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;

1339: IS
1340: l_return_status VARCHAR2(1);
1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1346: BEGIN
1347:

Line 1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;

1340: l_return_status VARCHAR2(1);
1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1346: BEGIN
1347:
1348: -- oe_debug_pub.add('inside lock list currency');

Line 1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

1341: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1342: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1343: l_x_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type;
1344: l_x_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1345: l_x_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;
1346: BEGIN
1347:
1348: -- oe_debug_pub.add('inside lock list currency');
1349:

Line 1471: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type

1467:
1468: -- Procedures maintaining CURR_DETAILS record cache.
1469:
1470: PROCEDURE Write_CURR_DETAILS
1471: ( p_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
1472: , p_db_record IN BOOLEAN := FALSE
1473: )
1474: IS
1475: BEGIN

Line 1491: RETURN QP_Currency_PUB.Curr_Details_Rec_Type

1487: FUNCTION Get_CURR_DETAILS
1488: ( p_db_record IN BOOLEAN := FALSE
1489: , p_currency_detail_id IN NUMBER
1490: )
1491: RETURN QP_Currency_PUB.Curr_Details_Rec_Type
1492: IS
1493: BEGIN
1494:
1495: IF p_currency_detail_id <> g_CURR_DETAILS_rec.currency_detail_id

Line 1528: g_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;

1524: PROCEDURE Clear_Curr_Details
1525: IS
1526: BEGIN
1527:
1528: g_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;
1529: g_db_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;
1530:
1531: END Clear_Curr_Details;
1532:

Line 1529: g_db_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;

1525: IS
1526: BEGIN
1527:
1528: g_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;
1529: g_db_CURR_DETAILS_rec := QP_Currency_PUB.G_MISS_CURR_DETAILS_REC;
1530:
1531: END Clear_Curr_Details;
1532:
1533: END QP_QP_Form_Curr_Details;