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_LIMIT_ATTRS dependencies on QP_LIMITS_PUB

Line 10: g_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Limit_Attrs';
7:
8: -- Global variables holding cached record.
9:
10: g_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
11: g_db_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
11: g_db_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_LIMIT_ATTRS

Line 16: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_LIMIT_ATTRS
16: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_LIMIT_ATTRS

Line 24: RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;

20: FUNCTION Get_LIMIT_ATTRS
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_limit_attribute_id IN NUMBER
23: )
24: RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type;
25:
26: PROCEDURE Clear_LIMIT_ATTRS;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

26: PROCEDURE Clear_LIMIT_ATTRS;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 67: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

63: , x_comparison_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: )
66: IS
67: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);

Line 68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;

64: , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: )
66: IS
67: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

Line 69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

65: )
66: IS
67: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

68: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

69: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
77: BEGIN

Line 74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

70: l_control_rec QP_GLOBALS.Control_Rec_Type;
71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
77: BEGIN
78:

Line 75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

71: l_return_status VARCHAR2(1);
72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
77: BEGIN
78:
79: -- Set control flags.

Line 76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

72: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
73: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
74: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
75: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
76: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
77: BEGIN
78:
79: -- Set control flags.
80:

Line 306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

302: , x_comparison_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: )
305: IS
306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

303: , x_limit OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: )
305: IS
306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;

304: )
305: IS
306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);

Line 309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

305: IS
306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

Line 310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

306: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
307: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
308: l_LIMIT_ATTRS_val_rec QP_Limits_PUB.Limit_Attrs_Val_Rec_Type;
309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

309: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

310: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
318: BEGIN

Line 315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
318: BEGIN
319:

Line 316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

312: l_return_status VARCHAR2(1);
313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
318: BEGIN
319:
320: -- Set control flags.

Line 317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

313: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
314: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
315: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
316: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
317: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
318: BEGIN
319:
320: -- Set control flags.
321:

Line 717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

713: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
714: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
715: )
716: IS
717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

714: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
715: )
716: IS
717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);

Line 719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

715: )
716: IS
717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

Line 720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

716: IS
717: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
718: l_old_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

719: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

720: l_old_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
728: BEGIN

Line 725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

721: l_control_rec QP_GLOBALS.Control_Rec_Type;
722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
728: BEGIN
729:

Line 726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

722: l_return_status VARCHAR2(1);
723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
728: BEGIN
729:
730: -- Set control flags.

Line 727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

723: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
724: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
725: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
726: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
727: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
728: BEGIN
729:
730: -- Set control flags.
731:

Line 879: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

875: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
876: , p_limit_attribute_id IN NUMBER
877: )
878: IS
879: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

Line 880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

876: , p_limit_attribute_id IN NUMBER
877: )
878: IS
879: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

Line 883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

879: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

880: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
888: BEGIN

Line 885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

881: l_control_rec QP_GLOBALS.Control_Rec_Type;
882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
888: BEGIN
889:

Line 886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

882: l_return_status VARCHAR2(1);
883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
888: BEGIN
889:
890: -- Set control flags.

Line 887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

883: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
884: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
885: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
886: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
887: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
888: BEGIN
889:
890: -- Set control flags.
891:

Line 1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

1010: )
1011: IS
1012: l_control_rec QP_GLOBALS.Control_Rec_Type;
1013: l_return_status VARCHAR2(1);
1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1011: IS
1012: l_control_rec QP_GLOBALS.Control_Rec_Type;
1013: l_return_status VARCHAR2(1);
1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1019: BEGIN

Line 1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1012: l_control_rec QP_GLOBALS.Control_Rec_Type;
1013: l_return_status VARCHAR2(1);
1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1019: BEGIN
1020:

Line 1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1013: l_return_status VARCHAR2(1);
1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1019: BEGIN
1020:
1021: -- Set control flags.

Line 1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1014: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1015: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1016: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1017: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1018: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1019: BEGIN
1020:
1021: -- Set control flags.
1022:

Line 1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1154: , p_request_id IN NUMBER
1155: )
1156: IS
1157: l_return_status VARCHAR2(1);
1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

Line 1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1155: )
1156: IS
1157: l_return_status VARCHAR2(1);
1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

Line 1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;

1156: IS
1157: l_return_status VARCHAR2(1);
1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

Line 1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;

1157: l_return_status VARCHAR2(1);
1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1165: BEGIN

Line 1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;

1158: l_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1165: BEGIN
1166:

Line 1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;

1159: l_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1165: BEGIN
1166:
1167: -- Load LIMIT_ATTRS record

Line 1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;

1160: l_x_LIMITS_rec QP_Limits_PUB.Limits_Rec_Type;
1161: l_x_LIMIT_ATTRS_rec QP_Limits_PUB.Limit_Attrs_Rec_Type;
1162: l_x_LIMIT_ATTRS_tbl QP_Limits_PUB.Limit_Attrs_Tbl_Type;
1163: l_x_LIMIT_BALANCES_rec QP_Limits_PUB.Limit_Balances_Rec_Type;
1164: l_x_LIMIT_BALANCES_tbl QP_Limits_PUB.Limit_Balances_Tbl_Type;
1165: BEGIN
1166:
1167: -- Load LIMIT_ATTRS record
1168:

Line 1274: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type

1270:
1271: -- Procedures maintaining LIMIT_ATTRS record cache.
1272:
1273: PROCEDURE Write_LIMIT_ATTRS
1274: ( p_LIMIT_ATTRS_rec IN QP_Limits_PUB.Limit_Attrs_Rec_Type
1275: , p_db_record IN BOOLEAN := FALSE
1276: )
1277: IS
1278: BEGIN

Line 1294: RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type

1290: FUNCTION Get_LIMIT_ATTRS
1291: ( p_db_record IN BOOLEAN := FALSE
1292: , p_limit_attribute_id IN NUMBER
1293: )
1294: RETURN QP_Limits_PUB.Limit_Attrs_Rec_Type
1295: IS
1296: BEGIN
1297:
1298: IF p_limit_attribute_id <> g_LIMIT_ATTRS_rec.limit_attribute_id

Line 1331: g_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;

1327: PROCEDURE Clear_Limit_Attrs
1328: IS
1329: BEGIN
1330:
1331: g_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;
1332: g_db_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;
1333:
1334: END Clear_Limit_Attrs;
1335:

Line 1332: g_db_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;

1328: IS
1329: BEGIN
1330:
1331: g_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;
1332: g_db_LIMIT_ATTRS_rec := QP_Limits_PUB.G_MISS_LIMIT_ATTRS_REC;
1333:
1334: END Clear_Limit_Attrs;
1335:
1336: END QP_QP_Form_Limit_Attrs;