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

Line 10: g_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

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

Line 11: g_db_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
11: g_db_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_FNA

Line 16: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

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

Line 24: RETURN QP_Attr_Map_PUB.Fna_Rec_Type;

20: FUNCTION Get_FNA
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_pte_sourcesystem_fnarea_id IN NUMBER
23: )
24: RETURN QP_Attr_Map_PUB.Fna_Rec_Type;
25:
26: PROCEDURE Clear_FNA;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

26: PROCEDURE Clear_FNA;
27:
28: -- Global variable holding performed operations.
29:
30: g_opr__tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
31:
32: -- Procedure : Check_Enabled_Fnas
33: --
34:

Line 83: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

79: , x_pte_source_system OUT NOCOPY VARCHAR2
80: , x_seeded OUT NOCOPY VARCHAR2
81: )
82: IS
83: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
84: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);

Line 84: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;

80: , x_seeded OUT NOCOPY VARCHAR2
81: )
82: IS
83: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
84: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

81: )
82: IS
83: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
84: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

84: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

85: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

86: l_control_rec QP_GLOBALS.Control_Rec_Type;
87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

87: l_return_status VARCHAR2(1);
88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

88: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

89: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

90: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

91: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
99: BEGIN

Line 96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

92: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
99: BEGIN
100:

Line 97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

93: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
99: BEGIN
100:
101: -- Set control flags.

Line 98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

94: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
95: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
96: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
97: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
98: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
99: BEGIN
100:
101: -- Set control flags.
102:

Line 331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

327: , x_pte_source_system OUT NOCOPY VARCHAR2
328: , x_seeded OUT NOCOPY VARCHAR2
329: )
330: IS
331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

328: , x_seeded OUT NOCOPY VARCHAR2
329: )
330: IS
331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;

329: )
330: IS
331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);

Line 334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

330: IS
331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

331: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
332: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
333: l_FNA_val_rec QP_Attr_Map_PUB.Fna_Val_Rec_Type;
334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

334: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

335: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

336: l_control_rec QP_GLOBALS.Control_Rec_Type;
337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

337: l_return_status VARCHAR2(1);
338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

338: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

339: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

340: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

341: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
349: BEGIN

Line 346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

342: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
349: BEGIN
350:

Line 347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

343: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
349: BEGIN
350:
351: -- Set control flags.

Line 348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

344: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
345: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
346: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
347: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
348: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
349: BEGIN
350:
351: -- Set control flags.
352:

Line 727: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

723: , x_last_updated_by OUT NOCOPY NUMBER
724: , x_last_update_login OUT NOCOPY NUMBER
725: )
726: IS
727: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
728: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 728: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

724: , x_last_update_login OUT NOCOPY NUMBER
725: )
726: IS
727: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
728: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);

Line 729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

725: )
726: IS
727: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
728: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

726: IS
727: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
728: l_old_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

729: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

730: l_old_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

731: l_control_rec QP_GLOBALS.Control_Rec_Type;
732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

732: l_return_status VARCHAR2(1);
733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

733: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

734: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

735: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

736: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
744: BEGIN

Line 741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

737: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
744: BEGIN
745:

Line 742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

738: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
744: BEGIN
745:
746: -- Set control flags.

Line 743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

739: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
740: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
741: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
742: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
743: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
744: BEGIN
745:
746: -- Set control flags.
747:

Line 898: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

894: , x_msg_data OUT NOCOPY VARCHAR2
895: , p_pte_sourcesystem_fnarea_id IN NUMBER
896: )
897: IS
898: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
899: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
900: l_control_rec QP_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 899: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

895: , p_pte_sourcesystem_fnarea_id IN NUMBER
896: )
897: IS
898: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
899: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
900: l_control_rec QP_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

898: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
899: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
900: l_control_rec QP_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

899: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
900: l_control_rec QP_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

900: l_control_rec QP_GLOBALS.Control_Rec_Type;
901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

901: l_return_status VARCHAR2(1);
902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

902: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

903: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

904: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

905: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
913: BEGIN

Line 910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

906: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
913: BEGIN
914:

Line 911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

907: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
913: BEGIN
914:
915: -- Set control flags.

Line 912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

908: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
909: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
910: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
911: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
912: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
913: BEGIN
914:
915: -- Set control flags.
916:

Line 1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1038: )
1039: IS
1040: l_control_rec QP_GLOBALS.Control_Rec_Type;
1041: l_return_status VARCHAR2(1);
1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1039: IS
1040: l_control_rec QP_GLOBALS.Control_Rec_Type;
1041: l_return_status VARCHAR2(1);
1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1040: l_control_rec QP_GLOBALS.Control_Rec_Type;
1041: l_return_status VARCHAR2(1);
1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1041: l_return_status VARCHAR2(1);
1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1042: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1043: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1044: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1045: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1053: BEGIN

Line 1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1046: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1053: BEGIN
1054:

Line 1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1047: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1053: BEGIN
1054:
1055: -- Set control flags.

Line 1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1048: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1049: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1050: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1051: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1052: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1053: BEGIN
1054:
1055: -- Set control flags.
1056:

Line 1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1188: , p_seeded_flag IN VARCHAR2
1189: )
1190: IS
1191: l_return_status VARCHAR2(1);
1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1189: )
1190: IS
1191: l_return_status VARCHAR2(1);
1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1190: IS
1191: l_return_status VARCHAR2(1);
1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1191: l_return_status VARCHAR2(1);
1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1192: l_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1193: l_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1194: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1195: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1196: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1197: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1205: BEGIN

Line 1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1198: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1205: BEGIN
1206:

Line 1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1199: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1205: BEGIN
1206:
1207: -- Load FNA record

Line 1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1200: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1201: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1202: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1203: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1204: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1205: BEGIN
1206:
1207: -- Load FNA record
1208:

Line 1314: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type

1310:
1311: -- Procedures maintaining FNA record cache.
1312:
1313: PROCEDURE Write_FNA
1314: ( p_FNA_rec IN QP_Attr_Map_PUB.Fna_Rec_Type
1315: , p_db_record IN BOOLEAN := FALSE
1316: )
1317: IS
1318: BEGIN

Line 1334: RETURN QP_Attr_Map_PUB.Fna_Rec_Type

1330: FUNCTION Get_FNA
1331: ( p_db_record IN BOOLEAN := FALSE
1332: , p_pte_sourcesystem_fnarea_id IN NUMBER
1333: )
1334: RETURN QP_Attr_Map_PUB.Fna_Rec_Type
1335: IS
1336: BEGIN
1337:
1338: IF p_pte_sourcesystem_fnarea_id <> g_FNA_rec.pte_sourcesystem_fnarea_id

Line 1371: g_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;

1367: PROCEDURE Clear_Fna
1368: IS
1369: BEGIN
1370:
1371: g_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;
1372: g_db_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;
1373:
1374: END Clear_Fna;
1375:

Line 1372: g_db_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;

1368: IS
1369: BEGIN
1370:
1371: g_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;
1372: g_db_FNA_rec := QP_Attr_Map_PUB.G_MISS_FNA_REC;
1373:
1374: END Clear_Fna;
1375:
1376: END QP_QP_Form_Fna;