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_RQT dependencies on QP_ATTR_MAP_PUB

Line 10: g_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_QP_Form_Rqt';
7:
8: -- Global variables holding cached record.
9:
10: g_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
11: g_db_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:

Line 11: g_db_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
11: g_db_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_RQT

Line 16: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_RQT
16: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
17: , p_db_record IN BOOLEAN := FALSE
18: );
19:
20: FUNCTION Get_RQT

Line 24: RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;

20: FUNCTION Get_RQT
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_request_type_code IN VARCHAR2
23: )
24: RETURN QP_Attr_Map_PUB.Rqt_Rec_Type;
25:
26: PROCEDURE Clear_RQT;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

26: PROCEDURE Clear_RQT;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
31:
32: -- Procedure : Default_Attributes
33: --
34:

Line 70: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

66: , x_request_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , x_row OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68: )
69: IS
70: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);

Line 71: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;

67: , x_row OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68: )
69: IS
70: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

68: )
69: IS
70: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

71: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

72: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

74: l_return_status VARCHAR2(1);
75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

75: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

76: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

77: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

78: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: BEGIN

Line 83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

79: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: BEGIN
87:

Line 84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

80: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: BEGIN
87:
88: -- Set control flags.

Line 85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

81: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
82: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
83: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
84: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
85: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: BEGIN
87:
88: -- Set control flags.
89:

Line 324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

320: , x_request_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
321: , x_row OUT NOCOPY /* file.sql.39 change */ VARCHAR2
322: )
323: IS
324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

321: , x_row OUT NOCOPY /* file.sql.39 change */ VARCHAR2
322: )
323: IS
324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;

322: )
323: IS
324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);

Line 327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

323: IS
324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

324: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
325: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
326: l_RQT_val_rec QP_Attr_Map_PUB.Rqt_Val_Rec_Type;
327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

327: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

328: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

330: l_return_status VARCHAR2(1);
331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

331: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

332: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

333: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

334: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
342: BEGIN

Line 339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

335: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
342: BEGIN
343:

Line 340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

336: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
342: BEGIN
343:
344: -- Set control flags.

Line 341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

337: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
338: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
339: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
340: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
341: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
342: BEGIN
343:
344: -- Set control flags.
345:

Line 756: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

752: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
753: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
754: )
755: IS
756: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
757: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 757: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

753: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
754: )
755: IS
756: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
757: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);

Line 758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

754: )
755: IS
756: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
757: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

755: IS
756: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
757: l_old_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

758: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

759: l_old_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

760: l_control_rec QP_GLOBALS.Control_Rec_Type;
761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

761: l_return_status VARCHAR2(1);
762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

762: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

763: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

764: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

765: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
773: BEGIN

Line 770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

766: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
773: BEGIN
774:

Line 771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

767: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
773: BEGIN
774:
775: -- Set control flags.

Line 772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

768: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
769: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
770: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
771: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
772: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
773: BEGIN
774:
775: -- Set control flags.
776:

Line 927: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

923: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
924: , p_request_type_code IN VARCHAR2
925: )
926: IS
927: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
928: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
929: l_control_rec QP_GLOBALS.Control_Rec_Type;
930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 928: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

924: , p_request_type_code IN VARCHAR2
925: )
926: IS
927: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
928: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
929: l_control_rec QP_GLOBALS.Control_Rec_Type;
930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

927: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
928: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
929: l_control_rec QP_GLOBALS.Control_Rec_Type;
930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

928: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
929: l_control_rec QP_GLOBALS.Control_Rec_Type;
930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

929: l_control_rec QP_GLOBALS.Control_Rec_Type;
930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

930: l_return_status VARCHAR2(1);
931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

931: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

932: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

933: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

934: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
942: BEGIN

Line 939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

935: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
942: BEGIN
943:

Line 940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

936: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
942: BEGIN
943:
944: -- Set control flags.

Line 941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

937: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
938: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
939: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
940: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
941: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
942: BEGIN
943:
944: -- Set control flags.
945:

Line 1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1067: )
1068: IS
1069: l_control_rec QP_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1068: IS
1069: l_control_rec QP_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1069: l_control_rec QP_GLOBALS.Control_Rec_Type;
1070: l_return_status VARCHAR2(1);
1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1070: l_return_status VARCHAR2(1);
1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1071: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1072: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1073: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1074: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1082: BEGIN

Line 1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1075: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1082: BEGIN
1083:

Line 1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1076: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1082: BEGIN
1083:
1084: -- Set control flags.

Line 1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1077: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1078: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1079: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1080: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1081: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1082: BEGIN
1083:
1084: -- Set control flags.
1085:

Line 1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1220: --**, p_row_id IN ROWID
1221: )
1222: IS
1223: l_return_status VARCHAR2(1);
1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1221: )
1222: IS
1223: l_return_status VARCHAR2(1);
1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1222: IS
1223: l_return_status VARCHAR2(1);
1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1223: l_return_status VARCHAR2(1);
1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1224: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1225: l_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1226: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1227: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1228: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1229: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1237: BEGIN

Line 1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1230: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1237: BEGIN
1238:

Line 1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1231: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1237: BEGIN
1238:
1239: -- Load RQT record

Line 1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1232: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1233: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1234: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1235: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1236: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1237: BEGIN
1238:
1239: -- Load RQT record
1240:

Line 1349: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type

1345:
1346: -- Procedures maintaining RQT record cache.
1347:
1348: PROCEDURE Write_RQT
1349: ( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
1350: , p_db_record IN BOOLEAN := FALSE
1351: )
1352: IS
1353: BEGIN

Line 1369: RETURN QP_Attr_Map_PUB.Rqt_Rec_Type

1365: FUNCTION Get_RQT
1366: ( p_db_record IN BOOLEAN := FALSE
1367: , p_request_type_code IN VARCHAR2
1368: )
1369: RETURN QP_Attr_Map_PUB.Rqt_Rec_Type
1370: IS
1371: BEGIN
1372:
1373: IF p_request_type_code <> g_RQT_rec.request_type_code

Line 1406: g_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;

1402: PROCEDURE Clear_Rqt
1403: IS
1404: BEGIN
1405:
1406: g_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;
1407: g_db_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;
1408:
1409: END Clear_Rqt;
1410:

Line 1407: g_db_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;

1403: IS
1404: BEGIN
1405:
1406: g_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;
1407: g_db_RQT_rec := QP_Attr_Map_PUB.G_MISS_RQT_REC;
1408:
1409: END Clear_Rqt;
1410:
1411: END QP_QP_Form_Rqt;