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

Line 10: g_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

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

Line 11: g_db_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
11: g_db_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_PSG

Line 16: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

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

Line 24: RETURN QP_Attr_Map_PUB.Psg_Rec_Type;

20: FUNCTION Get_PSG
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_segment_pte_id IN NUMBER
23: )
24: RETURN QP_Attr_Map_PUB.Psg_Rec_Type;
25:
26: PROCEDURE Clear_PSG;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

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

Line 70: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

66: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , x_segment_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68: )
69: IS
70: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
71: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
72: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
73: l_control_rec QP_GLOBALS.Control_Rec_Type;
74: l_return_status VARCHAR2(1);

Line 71: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;

67: , x_segment_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68: )
69: IS
70: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
71: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
72: l_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

68: )
69: IS
70: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
71: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
72: l_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
72: l_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

320: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
321: , x_segment_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
322: )
323: IS
324: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

321: , x_segment_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
322: )
323: IS
324: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;

322: )
323: IS
324: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
329: l_control_rec QP_GLOBALS.Control_Rec_Type;
330: l_return_status VARCHAR2(1);

Line 327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

323: IS
324: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

324: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
325: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
326: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
327: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
328: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_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_PSG_tbl QP_Attr_Map_PUB.Psg_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 763: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

759: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
760: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
761: )
762: IS
763: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
764: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 764: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

760: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
761: )
762: IS
763: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
764: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);

Line 765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

761: )
762: IS
763: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
764: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

762: IS
763: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
764: l_old_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

765: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

766: l_old_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

767: l_control_rec QP_GLOBALS.Control_Rec_Type;
768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

768: l_return_status VARCHAR2(1);
769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

769: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

770: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

771: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

772: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
780: BEGIN

Line 777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

773: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
780: BEGIN
781:

Line 778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

774: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
780: BEGIN
781:
782: -- Set control flags.

Line 779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

775: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
776: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
777: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
778: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
779: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
780: BEGIN
781:
782: -- Set control flags.
783:

Line 934: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

930: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
931: , p_segment_pte_id IN NUMBER
932: )
933: IS
934: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
935: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
936: l_control_rec QP_GLOBALS.Control_Rec_Type;
937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 935: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

931: , p_segment_pte_id IN NUMBER
932: )
933: IS
934: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
935: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
936: l_control_rec QP_GLOBALS.Control_Rec_Type;
937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

934: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
935: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
936: l_control_rec QP_GLOBALS.Control_Rec_Type;
937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

935: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
936: l_control_rec QP_GLOBALS.Control_Rec_Type;
937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

936: l_control_rec QP_GLOBALS.Control_Rec_Type;
937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

937: l_return_status VARCHAR2(1);
938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

938: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

939: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

940: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

941: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
949: BEGIN

Line 946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

942: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
949: BEGIN
950:

Line 947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

943: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
949: BEGIN
950:
951: -- Set control flags.

Line 948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

944: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
945: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
946: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
947: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
948: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
949: BEGIN
950:
951: -- Set control flags.
952:

Line 1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1074: )
1075: IS
1076: l_control_rec QP_GLOBALS.Control_Rec_Type;
1077: l_return_status VARCHAR2(1);
1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1075: IS
1076: l_control_rec QP_GLOBALS.Control_Rec_Type;
1077: l_return_status VARCHAR2(1);
1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1076: l_control_rec QP_GLOBALS.Control_Rec_Type;
1077: l_return_status VARCHAR2(1);
1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1077: l_return_status VARCHAR2(1);
1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1078: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1079: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1080: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1081: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1089: BEGIN

Line 1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1082: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1089: BEGIN
1090:

Line 1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1083: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1089: BEGIN
1090:
1091: -- Set control flags.

Line 1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1084: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1085: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1086: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1087: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1088: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1089: BEGIN
1090:
1091: -- Set control flags.
1092:

Line 1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1228: , p_user_sourcing_method IN VARCHAR2
1229: )
1230: IS
1231: l_return_status VARCHAR2(1);
1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1229: )
1230: IS
1231: l_return_status VARCHAR2(1);
1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1230: IS
1231: l_return_status VARCHAR2(1);
1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1231: l_return_status VARCHAR2(1);
1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1232: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1233: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1234: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1235: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1236: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1237: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1245: BEGIN

Line 1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1238: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1245: BEGIN
1246:

Line 1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1239: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1245: BEGIN
1246:
1247: -- Load PSG record

Line 1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1240: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1241: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1242: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1243: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1244: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1245: BEGIN
1246:
1247: -- Load PSG record
1248:

Line 1358: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type

1354:
1355: -- Procedures maintaining PSG record cache.
1356:
1357: PROCEDURE Write_PSG
1358: ( p_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
1359: , p_db_record IN BOOLEAN := FALSE
1360: )
1361: IS
1362: BEGIN

Line 1378: RETURN QP_Attr_Map_PUB.Psg_Rec_Type

1374: FUNCTION Get_PSG
1375: ( p_db_record IN BOOLEAN := FALSE
1376: , p_segment_pte_id IN NUMBER
1377: )
1378: RETURN QP_Attr_Map_PUB.Psg_Rec_Type
1379: IS
1380: BEGIN
1381:
1382: IF p_segment_pte_id <> g_PSG_rec.segment_pte_id

Line 1415: g_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;

1411: PROCEDURE Clear_Psg
1412: IS
1413: BEGIN
1414:
1415: g_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;
1416: g_db_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;
1417:
1418: END Clear_Psg;
1419:

Line 1416: g_db_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;

1412: IS
1413: BEGIN
1414:
1415: g_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;
1416: g_db_PSG_rec := QP_Attr_Map_PUB.G_MISS_PSG_REC;
1417:
1418: END Clear_Psg;
1419:
1420: END QP_QP_Form_Psg;