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

Line 10: g_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

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

Line 11: g_db_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
11: g_db_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_SSC

Line 16: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

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

Line 24: RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;

20: FUNCTION Get_SSC
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_pte_source_system_id IN NUMBER
23: )
24: RETURN QP_Attr_Map_PUB.Ssc_Rec_Type;
25:
26: PROCEDURE Clear_SSC;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

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

Line 64: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

60: , x_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_pte_source_system OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: )
63: IS
64: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
65: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);

Line 65: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;

61: , x_pte_source_system OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: )
63: IS
64: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
65: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

62: )
63: IS
64: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
65: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

65: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

66: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

67: l_control_rec QP_GLOBALS.Control_Rec_Type;
68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

68: l_return_status VARCHAR2(1);
69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

69: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

70: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

71: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

72: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
80: BEGIN

Line 77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

73: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
80: BEGIN
81:

Line 78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

74: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
80: BEGIN
81:
82: -- Set control flags.

Line 79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

75: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
76: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
77: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
78: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
79: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
80: BEGIN
81:
82: -- Set control flags.
83:

Line 306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

302: , x_pte OUT NOCOPY /* file.sql.39 change */ VARCHAR2
303: , x_pte_source_system OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: )
305: IS
306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

303: , x_pte_source_system OUT NOCOPY /* file.sql.39 change */ VARCHAR2
304: )
305: IS
306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;

304: )
305: IS
306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);

Line 309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

305: IS
306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

306: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
307: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
308: l_SSC_val_rec QP_Attr_Map_PUB.Ssc_Val_Rec_Type;
309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

309: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

310: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

311: l_control_rec QP_GLOBALS.Control_Rec_Type;
312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

312: l_return_status VARCHAR2(1);
313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

313: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

314: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

315: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

316: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
324: BEGIN

Line 321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

317: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
324: BEGIN
325:

Line 322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

318: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
324: BEGIN
325:
326: -- Set control flags.

Line 323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

319: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
320: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
321: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
322: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
323: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
324: BEGIN
325:
326: -- Set control flags.
327:

Line 691: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

687: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
688: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
689: )
690: IS
691: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
692: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 692: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

688: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
689: )
690: IS
691: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
692: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);

Line 693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

689: )
690: IS
691: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
692: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

690: IS
691: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
692: l_old_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

693: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

694: l_old_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

695: l_control_rec QP_GLOBALS.Control_Rec_Type;
696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

696: l_return_status VARCHAR2(1);
697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

697: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

698: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

699: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

700: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
708: BEGIN

Line 705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

701: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
708: BEGIN
709:

Line 706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

702: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
708: BEGIN
709:
710: -- Set control flags.

Line 707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

703: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
704: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
705: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
706: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
707: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
708: BEGIN
709:
710: -- Set control flags.
711:

Line 862: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

858: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
859: , p_pte_source_system_id IN NUMBER
860: )
861: IS
862: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
863: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
864: l_control_rec QP_GLOBALS.Control_Rec_Type;
865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 863: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

859: , p_pte_source_system_id IN NUMBER
860: )
861: IS
862: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
863: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
864: l_control_rec QP_GLOBALS.Control_Rec_Type;
865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

862: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
863: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
864: l_control_rec QP_GLOBALS.Control_Rec_Type;
865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

863: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
864: l_control_rec QP_GLOBALS.Control_Rec_Type;
865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

864: l_control_rec QP_GLOBALS.Control_Rec_Type;
865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

865: l_return_status VARCHAR2(1);
866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

866: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

867: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

868: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

869: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
877: BEGIN

Line 874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

870: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
877: BEGIN
878:

Line 875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

871: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
877: BEGIN
878:
879: -- Set control flags.

Line 876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

872: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
873: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
874: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
875: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
876: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
877: BEGIN
878:
879: -- Set control flags.
880:

Line 1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1002: )
1003: IS
1004: l_control_rec QP_GLOBALS.Control_Rec_Type;
1005: l_return_status VARCHAR2(1);
1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1003: IS
1004: l_control_rec QP_GLOBALS.Control_Rec_Type;
1005: l_return_status VARCHAR2(1);
1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1004: l_control_rec QP_GLOBALS.Control_Rec_Type;
1005: l_return_status VARCHAR2(1);
1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1005: l_return_status VARCHAR2(1);
1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1006: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1007: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1008: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1009: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1017: BEGIN

Line 1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1010: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1017: BEGIN
1018:

Line 1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1011: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1017: BEGIN
1018:
1019: -- Set control flags.

Line 1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1012: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1013: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1014: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1015: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1016: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1017: BEGIN
1018:
1019: -- Set control flags.
1020:

Line 1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1150: , p_pte_source_system_id IN NUMBER
1151: )
1152: IS
1153: l_return_status VARCHAR2(1);
1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1151: )
1152: IS
1153: l_return_status VARCHAR2(1);
1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1152: IS
1153: l_return_status VARCHAR2(1);
1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1153: l_return_status VARCHAR2(1);
1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1154: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1155: l_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1156: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1157: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1158: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1159: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1167: BEGIN

Line 1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1160: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1167: BEGIN
1168:

Line 1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1161: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1167: BEGIN
1168:
1169: -- Load SSC record

Line 1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1162: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1163: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1164: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1165: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1166: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1167: BEGIN
1168:
1169: -- Load SSC record
1170:

Line 1274: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type

1270:
1271: -- Procedures maintaining SSC record cache.
1272:
1273: PROCEDURE Write_SSC
1274: ( p_SSC_rec IN QP_Attr_Map_PUB.Ssc_Rec_Type
1275: , p_db_record IN BOOLEAN := FALSE
1276: )
1277: IS
1278: BEGIN

Line 1294: RETURN QP_Attr_Map_PUB.Ssc_Rec_Type

1290: FUNCTION Get_SSC
1291: ( p_db_record IN BOOLEAN := FALSE
1292: , p_pte_source_system_id IN NUMBER
1293: )
1294: RETURN QP_Attr_Map_PUB.Ssc_Rec_Type
1295: IS
1296: BEGIN
1297:
1298: IF p_pte_source_system_id <> g_SSC_rec.pte_source_system_id

Line 1331: g_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;

1327: PROCEDURE Clear_Ssc
1328: IS
1329: BEGIN
1330:
1331: g_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;
1332: g_db_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;
1333:
1334: END Clear_Ssc;
1335:

Line 1332: g_db_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;

1328: IS
1329: BEGIN
1330:
1331: g_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;
1332: g_db_SSC_rec := QP_Attr_Map_PUB.G_MISS_SSC_REC;
1333:
1334: END Clear_Ssc;
1335:
1336: END QP_QP_Form_Ssc;