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

Line 10: g_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

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

Line 11: g_db_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
11: g_db_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
12:
13: -- Forward declaration of procedures maintaining entity record cache.
14:
15: PROCEDURE Write_SOU

Line 16: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

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

Line 24: RETURN QP_Attr_Map_PUB.Sou_Rec_Type;

20: FUNCTION Get_SOU
21: ( p_db_record IN BOOLEAN := FALSE
22: , p_attribute_sourcing_id IN NUMBER
23: )
24: RETURN QP_Attr_Map_PUB.Sou_Rec_Type;
25:
26: PROCEDURE Clear_SOU;
27:
28: -- Global variable holding performed operations.

Line 30: g_opr__tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

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

Line 73: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

69: , x_seeded OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71: )
72: IS
73: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
74: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77: l_return_status VARCHAR2(1);

Line 74: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;

70: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71: )
72: IS
73: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
74: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77: l_return_status VARCHAR2(1);
78: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

71: )
72: IS
73: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
74: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77: l_return_status VARCHAR2(1);
78: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
79: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 78: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

74: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77: l_return_status VARCHAR2(1);
78: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
79: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
80: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
81: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
82: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 79: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

75: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77: l_return_status VARCHAR2(1);
78: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
79: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
80: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
81: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
82: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
83: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 80: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

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

Line 81: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

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

Line 82: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

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

Line 83: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

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

Line 84: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

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

Line 85: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

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

Line 86: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

82: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
83: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
84: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
85: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
86: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
87: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
88: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
89: BEGIN
90: oe_debug_pub.add('in QPXFSOUB.pls -- Default attributes');

Line 87: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

83: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
84: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
85: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
86: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
87: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
88: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
89: BEGIN
90: oe_debug_pub.add('in QPXFSOUB.pls -- Default attributes');
91:

Line 88: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

84: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
85: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
86: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
87: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
88: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
89: BEGIN
90: oe_debug_pub.add('in QPXFSOUB.pls -- Default attributes');
91:
92: -- Set control flags.

Line 334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

330: , x_seeded OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
332: )
333: IS
334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

331: , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
332: )
333: IS
334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;

332: )
333: IS
334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;
340: l_return_status VARCHAR2(1);

Line 337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

333: IS
334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;
340: l_return_status VARCHAR2(1);
341: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

334: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
335: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
336: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;
340: l_return_status VARCHAR2(1);
341: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
342: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 341: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

337: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;
340: l_return_status VARCHAR2(1);
341: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
342: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
343: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
344: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
345: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 342: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

338: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
339: l_control_rec QP_GLOBALS.Control_Rec_Type;
340: l_return_status VARCHAR2(1);
341: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
342: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
343: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
344: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
345: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
346: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 343: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

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

Line 344: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

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

Line 345: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

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

Line 346: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

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

Line 347: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

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

Line 348: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

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

Line 349: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

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

Line 350: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

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

Line 351: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

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

Line 784: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

780: , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
781: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
782: )
783: IS
784: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
785: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;

Line 785: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

781: , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
782: )
783: IS
784: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
785: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);

Line 786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

782: )
783: IS
784: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
785: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

783: IS
784: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
785: l_old_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

786: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

787: l_old_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

788: l_control_rec QP_GLOBALS.Control_Rec_Type;
789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

789: l_return_status VARCHAR2(1);
790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

790: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

791: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

792: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

793: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
801: BEGIN

Line 798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

794: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
801: BEGIN
802:

Line 799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

795: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
801: BEGIN
802:
803: -- Set control flags.

Line 800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

796: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
797: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
798: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
799: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
800: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
801: BEGIN
802:
803: -- Set control flags.
804:

Line 955: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

951: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
952: , p_attribute_sourcing_id IN NUMBER
953: )
954: IS
955: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
956: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
957: l_control_rec QP_GLOBALS.Control_Rec_Type;
958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

Line 956: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

952: , p_attribute_sourcing_id IN NUMBER
953: )
954: IS
955: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
956: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
957: l_control_rec QP_GLOBALS.Control_Rec_Type;
958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

Line 959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

955: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
956: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
957: l_control_rec QP_GLOBALS.Control_Rec_Type;
958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

956: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
957: l_control_rec QP_GLOBALS.Control_Rec_Type;
958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

957: l_control_rec QP_GLOBALS.Control_Rec_Type;
958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

958: l_return_status VARCHAR2(1);
959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

959: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

960: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

961: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

962: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
970: BEGIN

Line 967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

963: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
970: BEGIN
971:

Line 968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

964: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
970: BEGIN
971:
972: -- Set control flags.

Line 969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

965: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
966: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
967: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
968: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
969: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
970: BEGIN
971:
972: -- Set control flags.
973:

Line 1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1095: )
1096: IS
1097: l_control_rec QP_GLOBALS.Control_Rec_Type;
1098: l_return_status VARCHAR2(1);
1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1096: IS
1097: l_control_rec QP_GLOBALS.Control_Rec_Type;
1098: l_return_status VARCHAR2(1);
1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1097: l_control_rec QP_GLOBALS.Control_Rec_Type;
1098: l_return_status VARCHAR2(1);
1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1098: l_return_status VARCHAR2(1);
1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1099: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1100: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1101: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1102: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1110: BEGIN

Line 1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1103: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1110: BEGIN
1111:

Line 1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1104: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1110: BEGIN
1111:
1112: -- Set control flags.

Line 1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1105: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1106: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1107: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1108: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1109: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1110: BEGIN
1111:
1112: -- Set control flags.
1113:

Line 1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1250: , p_user_value_string IN VARCHAR2
1251: )
1252: IS
1253: l_return_status VARCHAR2(1);
1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

Line 1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1251: )
1252: IS
1253: l_return_status VARCHAR2(1);
1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

Line 1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;

1252: IS
1253: l_return_status VARCHAR2(1);
1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

Line 1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;

1253: l_return_status VARCHAR2(1);
1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

Line 1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;

1254: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;

1255: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;

1256: l_x_PTE_rec QP_Attr_Map_PUB.Pte_Rec_Type;
1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;

1257: l_x_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

Line 1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

1258: l_x_RQT_tbl QP_Attr_Map_PUB.Rqt_Tbl_Type;
1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

Line 1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

1259: l_x_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1267: BEGIN

Line 1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

1260: l_x_SSC_tbl QP_Attr_Map_PUB.Ssc_Tbl_Type;
1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1267: BEGIN
1268:

Line 1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;

1261: l_x_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1267: BEGIN
1268:
1269: -- Load SOU record

Line 1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;

1262: l_x_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;
1263: l_x_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1264: l_x_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;
1265: l_x_FNA_rec QP_Attr_Map_PUB.Fna_Rec_Type;
1266: l_x_FNA_tbl QP_Attr_Map_PUB.Fna_Tbl_Type;
1267: BEGIN
1268:
1269: -- Load SOU record
1270:

Line 1381: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type

1377:
1378: -- Procedures maintaining SOU record cache.
1379:
1380: PROCEDURE Write_SOU
1381: ( p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
1382: , p_db_record IN BOOLEAN := FALSE
1383: )
1384: IS
1385: BEGIN

Line 1401: RETURN QP_Attr_Map_PUB.Sou_Rec_Type

1397: FUNCTION Get_SOU
1398: ( p_db_record IN BOOLEAN := FALSE
1399: , p_attribute_sourcing_id IN NUMBER
1400: )
1401: RETURN QP_Attr_Map_PUB.Sou_Rec_Type
1402: IS
1403: BEGIN
1404:
1405: IF p_attribute_sourcing_id <> g_SOU_rec.attribute_sourcing_id

Line 1438: g_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;

1434: PROCEDURE Clear_Sou
1435: IS
1436: BEGIN
1437:
1438: g_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;
1439: g_db_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;
1440:
1441: END Clear_Sou;
1442:

Line 1439: g_db_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;

1435: IS
1436: BEGIN
1437:
1438: g_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;
1439: g_db_SOU_rec := QP_Attr_Map_PUB.G_MISS_SOU_REC;
1440:
1441: END Clear_Sou;
1442:
1443: END QP_QP_Form_Sou;