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:
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
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
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.
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:
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);
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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.
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:
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;
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;
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);
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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.
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:
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;
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);
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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.
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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.
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:
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;
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;
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;
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;
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;
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;
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;
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
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:
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.
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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:
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
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:
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
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
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:
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;