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.PON_OPEN_INTERFACE_PVT dependencies on ALLOWED_VALUE_COLUMN_OBJECT

Line 7: TYPE column_test_table IS TABLE OF allowed_value_column_object;

3:
4: --TYPE allowed_values_table IS TABLE OF VARCHAR2(20);
5: neg_header_record_data neg_header_record;
6:
7: TYPE column_test_table IS TABLE OF allowed_value_column_object;
8: allowed_values_table_data allowed_values_table;
9: yn_data allowed_values_table;
10: object_data allowed_value_column_object;
11: column_test_table_data column_test_table := column_test_table();

Line 10: object_data allowed_value_column_object;

6:
7: TYPE column_test_table IS TABLE OF allowed_value_column_object;
8: allowed_values_table_data allowed_values_table;
9: yn_data allowed_values_table;
10: object_data allowed_value_column_object;
11: column_test_table_data column_test_table := column_test_table();
12:
13: TYPE validate_header_col_table IS TABLE OF VARCHAR2(50);
14: header_cols validate_header_col_table := validate_header_col_table

Line 64: object_data := allowed_value_column_object('CONTRACT_TYPE',allowed_values_table_data);

60: BEGIN
61: column_test_table_data.extend(31);
62: yn_data := allowed_values_table('Y','N');
63: allowed_values_table_data := allowed_values_table('CONTRACT','BLANKET','STANDARD');
64: object_data := allowed_value_column_object('CONTRACT_TYPE',allowed_values_table_data);
65: column_test_table_data(1) := object_data;
66: allowed_values_table_data := allowed_values_table('PUBLIC','PRIVATE','HIERARCHY');
67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))
68: column_test_table_data(2) := object_data;

Line 67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))

63: allowed_values_table_data := allowed_values_table('CONTRACT','BLANKET','STANDARD');
64: object_data := allowed_value_column_object('CONTRACT_TYPE',allowed_values_table_data);
65: column_test_table_data(1) := object_data;
66: allowed_values_table_data := allowed_values_table('PUBLIC','PRIVATE','HIERARCHY');
67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))
68: column_test_table_data(2) := object_data;
69: IF(p_contract_type IN ('BLANKET','CONTRACT')) THEN
70: object_data := allowed_value_column_object('GLOBAL_AGREEMENT_FLAG',yn_data);
71: column_test_table_data(3) := object_data;

Line 70: object_data := allowed_value_column_object('GLOBAL_AGREEMENT_FLAG',yn_data);

66: allowed_values_table_data := allowed_values_table('PUBLIC','PRIVATE','HIERARCHY');
67: object_data := allowed_value_column_object('SECURITY_LEVEL_CODE',allowed_values_table_data); --SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PON_SECURITY_LEVEL_CODE' AND LANGUAGE=UserEnv('LANG'))
68: column_test_table_data(2) := object_data;
69: IF(p_contract_type IN ('BLANKET','CONTRACT')) THEN
70: object_data := allowed_value_column_object('GLOBAL_AGREEMENT_FLAG',yn_data);
71: column_test_table_data(3) := object_data;
72: END IF;
73: object_data := allowed_value_column_object('PUBLISH_RATES_TO_BIDDERS_FLAG',yn_data);
74: column_test_table_data(4) := object_data;

Line 73: object_data := allowed_value_column_object('PUBLISH_RATES_TO_BIDDERS_FLAG',yn_data);

69: IF(p_contract_type IN ('BLANKET','CONTRACT')) THEN
70: object_data := allowed_value_column_object('GLOBAL_AGREEMENT_FLAG',yn_data);
71: column_test_table_data(3) := object_data;
72: END IF;
73: object_data := allowed_value_column_object('PUBLISH_RATES_TO_BIDDERS_FLAG',yn_data);
74: column_test_table_data(4) := object_data;
75: object_data := allowed_value_column_object('OPEN_AUCTION_NOW_FLAG',yn_data);
76: column_test_table_data(5) := object_data;
77: object_data := allowed_value_column_object('PUBLISH_AUCTION_NOW_FLAG',yn_data);

Line 75: object_data := allowed_value_column_object('OPEN_AUCTION_NOW_FLAG',yn_data);

71: column_test_table_data(3) := object_data;
72: END IF;
73: object_data := allowed_value_column_object('PUBLISH_RATES_TO_BIDDERS_FLAG',yn_data);
74: column_test_table_data(4) := object_data;
75: object_data := allowed_value_column_object('OPEN_AUCTION_NOW_FLAG',yn_data);
76: column_test_table_data(5) := object_data;
77: object_data := allowed_value_column_object('PUBLISH_AUCTION_NOW_FLAG',yn_data);
78: column_test_table_data(6) := object_data;
79: allowed_values_table_data := allowed_values_table('OPEN_BIDDING', 'SEALED_BIDDING', 'SEALED_AUCTION');

Line 77: object_data := allowed_value_column_object('PUBLISH_AUCTION_NOW_FLAG',yn_data);

73: object_data := allowed_value_column_object('PUBLISH_RATES_TO_BIDDERS_FLAG',yn_data);
74: column_test_table_data(4) := object_data;
75: object_data := allowed_value_column_object('OPEN_AUCTION_NOW_FLAG',yn_data);
76: column_test_table_data(5) := object_data;
77: object_data := allowed_value_column_object('PUBLISH_AUCTION_NOW_FLAG',yn_data);
78: column_test_table_data(6) := object_data;
79: allowed_values_table_data := allowed_values_table('OPEN_BIDDING', 'SEALED_BIDDING', 'SEALED_AUCTION');
80: object_data := allowed_value_column_object('BID_VISIBILITY_CODE',allowed_values_table_data);
81: column_test_table_data(7) := object_data;

Line 80: object_data := allowed_value_column_object('BID_VISIBILITY_CODE',allowed_values_table_data);

76: column_test_table_data(5) := object_data;
77: object_data := allowed_value_column_object('PUBLISH_AUCTION_NOW_FLAG',yn_data);
78: column_test_table_data(6) := object_data;
79: allowed_values_table_data := allowed_values_table('OPEN_BIDDING', 'SEALED_BIDDING', 'SEALED_AUCTION');
80: object_data := allowed_value_column_object('BID_VISIBILITY_CODE',allowed_values_table_data);
81: column_test_table_data(7) := object_data;
82: allowed_values_table_data := allowed_values_table('LINE_LEVEL_BIDDING', 'MUST_BID_ALL_ITEMS');
83: object_data := allowed_value_column_object('BID_SCOPE_CODE',allowed_values_table_data);
84: column_test_table_data(8) := object_data;

Line 83: object_data := allowed_value_column_object('BID_SCOPE_CODE',allowed_values_table_data);

79: allowed_values_table_data := allowed_values_table('OPEN_BIDDING', 'SEALED_BIDDING', 'SEALED_AUCTION');
80: object_data := allowed_value_column_object('BID_VISIBILITY_CODE',allowed_values_table_data);
81: column_test_table_data(7) := object_data;
82: allowed_values_table_data := allowed_values_table('LINE_LEVEL_BIDDING', 'MUST_BID_ALL_ITEMS');
83: object_data := allowed_value_column_object('BID_SCOPE_CODE',allowed_values_table_data);
84: column_test_table_data(8) := object_data;
85: allowed_values_table_data := allowed_values_table('PUBLIC_BID_LIST', 'PRIVATE_BID_LIST');
86: object_data := allowed_value_column_object('BID_LIST_TYPE',allowed_values_table_data);
87: column_test_table_data(9) := object_data;

Line 86: object_data := allowed_value_column_object('BID_LIST_TYPE',allowed_values_table_data);

82: allowed_values_table_data := allowed_values_table('LINE_LEVEL_BIDDING', 'MUST_BID_ALL_ITEMS');
83: object_data := allowed_value_column_object('BID_SCOPE_CODE',allowed_values_table_data);
84: column_test_table_data(8) := object_data;
85: allowed_values_table_data := allowed_values_table('PUBLIC_BID_LIST', 'PRIVATE_BID_LIST');
86: object_data := allowed_value_column_object('BID_LIST_TYPE',allowed_values_table_data);
87: column_test_table_data(9) := object_data;
88: allowed_values_table_data := allowed_values_table('SINGLE_BID_ONLY', 'MULTIPLE_BIDS_ALLOWED');
89: object_data := allowed_value_column_object('BID_FREQUENCY_CODE',allowed_values_table_data);
90: column_test_table_data(10) := object_data;

Line 89: object_data := allowed_value_column_object('BID_FREQUENCY_CODE',allowed_values_table_data);

85: allowed_values_table_data := allowed_values_table('PUBLIC_BID_LIST', 'PRIVATE_BID_LIST');
86: object_data := allowed_value_column_object('BID_LIST_TYPE',allowed_values_table_data);
87: column_test_table_data(9) := object_data;
88: allowed_values_table_data := allowed_values_table('SINGLE_BID_ONLY', 'MULTIPLE_BIDS_ALLOWED');
89: object_data := allowed_value_column_object('BID_FREQUENCY_CODE',allowed_values_table_data);
90: column_test_table_data(10) := object_data;
91: allowed_values_table_data := allowed_values_table('PRICE_ONLY','MULTI_ATTRIBUTE_SCORING');
92: object_data := allowed_value_column_object('BID_RANKING',allowed_values_table_data);
93: column_test_table_data(11) := object_data;

Line 92: object_data := allowed_value_column_object('BID_RANKING',allowed_values_table_data);

88: allowed_values_table_data := allowed_values_table('SINGLE_BID_ONLY', 'MULTIPLE_BIDS_ALLOWED');
89: object_data := allowed_value_column_object('BID_FREQUENCY_CODE',allowed_values_table_data);
90: column_test_table_data(10) := object_data;
91: allowed_values_table_data := allowed_values_table('PRICE_ONLY','MULTI_ATTRIBUTE_SCORING');
92: object_data := allowed_value_column_object('BID_RANKING',allowed_values_table_data);
93: column_test_table_data(11) := object_data;
94: allowed_values_table_data := allowed_values_table('NONE','WIN_LOSE','NUMBERING');
95: object_data := allowed_value_column_object('RANKING_INDICATOR',allowed_values_table_data);
96: column_test_table_data(12) := object_data;

Line 95: object_data := allowed_value_column_object('RANKING_INDICATOR',allowed_values_table_data);

91: allowed_values_table_data := allowed_values_table('PRICE_ONLY','MULTI_ATTRIBUTE_SCORING');
92: object_data := allowed_value_column_object('BID_RANKING',allowed_values_table_data);
93: column_test_table_data(11) := object_data;
94: allowed_values_table_data := allowed_values_table('NONE','WIN_LOSE','NUMBERING');
95: object_data := allowed_value_column_object('RANKING_INDICATOR',allowed_values_table_data);
96: column_test_table_data(12) := object_data;
97: allowed_values_table_data := allowed_values_table('PARTIAL_QTY_BIDS_ALLOWED', 'FULL_QTY_BIDS_REQD');
98: object_data := allowed_value_column_object('FULL_QUANTITY_BID_CODE',allowed_values_table_data);
99: column_test_table_data(13) := object_data;

Line 98: object_data := allowed_value_column_object('FULL_QUANTITY_BID_CODE',allowed_values_table_data);

94: allowed_values_table_data := allowed_values_table('NONE','WIN_LOSE','NUMBERING');
95: object_data := allowed_value_column_object('RANKING_INDICATOR',allowed_values_table_data);
96: column_test_table_data(12) := object_data;
97: allowed_values_table_data := allowed_values_table('PARTIAL_QTY_BIDS_ALLOWED', 'FULL_QTY_BIDS_REQD');
98: object_data := allowed_value_column_object('FULL_QUANTITY_BID_CODE',allowed_values_table_data);
99: column_test_table_data(13) := object_data;
100: IF(p_auction_type NOT IN ('REQUEST_FOR_QUOTE','SOLICITATION')) THEN
101: object_data := allowed_value_column_object('MULTIPLE_ROUNDS_FLAG',yn_data);
102: column_test_table_data(14) := object_data;

Line 101: object_data := allowed_value_column_object('MULTIPLE_ROUNDS_FLAG',yn_data);

97: allowed_values_table_data := allowed_values_table('PARTIAL_QTY_BIDS_ALLOWED', 'FULL_QTY_BIDS_REQD');
98: object_data := allowed_value_column_object('FULL_QUANTITY_BID_CODE',allowed_values_table_data);
99: column_test_table_data(13) := object_data;
100: IF(p_auction_type NOT IN ('REQUEST_FOR_QUOTE','SOLICITATION')) THEN
101: object_data := allowed_value_column_object('MULTIPLE_ROUNDS_FLAG',yn_data);
102: column_test_table_data(14) := object_data;
103: END IF;
104: object_data := allowed_value_column_object('MANUAL_CLOSE_FLAG',yn_data);
105: column_test_table_data(15) := object_data;

Line 104: object_data := allowed_value_column_object('MANUAL_CLOSE_FLAG',yn_data);

100: IF(p_auction_type NOT IN ('REQUEST_FOR_QUOTE','SOLICITATION')) THEN
101: object_data := allowed_value_column_object('MULTIPLE_ROUNDS_FLAG',yn_data);
102: column_test_table_data(14) := object_data;
103: END IF;
104: object_data := allowed_value_column_object('MANUAL_CLOSE_FLAG',yn_data);
105: column_test_table_data(15) := object_data;
106: IF(p_auction_type <> 'SOLICITATION') THEN
107: object_data := allowed_value_column_object('MANUAL_EXTEND_FLAG',yn_data);
108: column_test_table_data(16) := object_data;

Line 107: object_data := allowed_value_column_object('MANUAL_EXTEND_FLAG',yn_data);

103: END IF;
104: object_data := allowed_value_column_object('MANUAL_CLOSE_FLAG',yn_data);
105: column_test_table_data(15) := object_data;
106: IF(p_auction_type <> 'SOLICITATION') THEN
107: object_data := allowed_value_column_object('MANUAL_EXTEND_FLAG',yn_data);
108: column_test_table_data(16) := object_data;
109: END IF;
110: object_data := allowed_value_column_object('AWARD_APPROVAL_FLAG',yn_data);
111: column_test_table_data(17) := object_data;

Line 110: object_data := allowed_value_column_object('AWARD_APPROVAL_FLAG',yn_data);

106: IF(p_auction_type <> 'SOLICITATION') THEN
107: object_data := allowed_value_column_object('MANUAL_EXTEND_FLAG',yn_data);
108: column_test_table_data(16) := object_data;
109: END IF;
110: object_data := allowed_value_column_object('AWARD_APPROVAL_FLAG',yn_data);
111: column_test_table_data(17) := object_data;
112: allowed_values_table_data := allowed_values_table('REQUISITION', 'BLANKET');
113: object_data := allowed_value_column_object('AUCTION_ORIGINATION_CODE',allowed_values_table_data);
114: column_test_table_data(18) := object_data;

Line 113: object_data := allowed_value_column_object('AUCTION_ORIGINATION_CODE',allowed_values_table_data);

109: END IF;
110: object_data := allowed_value_column_object('AWARD_APPROVAL_FLAG',yn_data);
111: column_test_table_data(17) := object_data;
112: allowed_values_table_data := allowed_values_table('REQUISITION', 'BLANKET');
113: object_data := allowed_value_column_object('AUCTION_ORIGINATION_CODE',allowed_values_table_data);
114: column_test_table_data(18) := object_data;
115: IF(p_is_complex = 'Y') THEN
116: object_data := allowed_value_column_object('ADVANCE_NEGOTIABLE_FLAG',yn_data);
117: column_test_table_data(19) := object_data;

Line 116: object_data := allowed_value_column_object('ADVANCE_NEGOTIABLE_FLAG',yn_data);

112: allowed_values_table_data := allowed_values_table('REQUISITION', 'BLANKET');
113: object_data := allowed_value_column_object('AUCTION_ORIGINATION_CODE',allowed_values_table_data);
114: column_test_table_data(18) := object_data;
115: IF(p_is_complex = 'Y') THEN
116: object_data := allowed_value_column_object('ADVANCE_NEGOTIABLE_FLAG',yn_data);
117: column_test_table_data(19) := object_data;
118: object_data := allowed_value_column_object('RECOUPMENT_NEGOTIABLE_FLAG',yn_data);
119: column_test_table_data(20) := object_data;
120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);

Line 118: object_data := allowed_value_column_object('RECOUPMENT_NEGOTIABLE_FLAG',yn_data);

114: column_test_table_data(18) := object_data;
115: IF(p_is_complex = 'Y') THEN
116: object_data := allowed_value_column_object('ADVANCE_NEGOTIABLE_FLAG',yn_data);
117: column_test_table_data(19) := object_data;
118: object_data := allowed_value_column_object('RECOUPMENT_NEGOTIABLE_FLAG',yn_data);
119: column_test_table_data(20) := object_data;
120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);
121: column_test_table_data(21) := object_data;
122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);

Line 120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);

116: object_data := allowed_value_column_object('ADVANCE_NEGOTIABLE_FLAG',yn_data);
117: column_test_table_data(19) := object_data;
118: object_data := allowed_value_column_object('RECOUPMENT_NEGOTIABLE_FLAG',yn_data);
119: column_test_table_data(20) := object_data;
120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);
121: column_test_table_data(21) := object_data;
122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);
123: column_test_table_data(22) := object_data;
124: object_data := allowed_value_column_object('MAX_RETAINAGE_NEGOTIABLE_FLAG',yn_data);

Line 122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);

118: object_data := allowed_value_column_object('RECOUPMENT_NEGOTIABLE_FLAG',yn_data);
119: column_test_table_data(20) := object_data;
120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);
121: column_test_table_data(21) := object_data;
122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);
123: column_test_table_data(22) := object_data;
124: object_data := allowed_value_column_object('MAX_RETAINAGE_NEGOTIABLE_FLAG',yn_data);
125: column_test_table_data(23) := object_data;
126: object_data := allowed_value_column_object('SUPPLIER_ENTERABLE_PYMT_FLAG',yn_data);

Line 124: object_data := allowed_value_column_object('MAX_RETAINAGE_NEGOTIABLE_FLAG',yn_data);

120: object_data := allowed_value_column_object('PROGRESS_PYMT_NEGOTIABLE_FLAG',yn_data);
121: column_test_table_data(21) := object_data;
122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);
123: column_test_table_data(22) := object_data;
124: object_data := allowed_value_column_object('MAX_RETAINAGE_NEGOTIABLE_FLAG',yn_data);
125: column_test_table_data(23) := object_data;
126: object_data := allowed_value_column_object('SUPPLIER_ENTERABLE_PYMT_FLAG',yn_data);
127: column_test_table_data(24) := object_data;
128: END IF;

Line 126: object_data := allowed_value_column_object('SUPPLIER_ENTERABLE_PYMT_FLAG',yn_data);

122: object_data := allowed_value_column_object('RETAINAGE_NEGOTIABLE_FLAG',yn_data);
123: column_test_table_data(22) := object_data;
124: object_data := allowed_value_column_object('MAX_RETAINAGE_NEGOTIABLE_FLAG',yn_data);
125: column_test_table_data(23) := object_data;
126: object_data := allowed_value_column_object('SUPPLIER_ENTERABLE_PYMT_FLAG',yn_data);
127: column_test_table_data(24) := object_data;
128: END IF;
129: IF(p_auction_type IN ('REQUEST_FOR_QUOTE','SOLICITATION')) THEN
130: object_data := allowed_value_column_object('TWO_PART_FLAG',yn_data);

Line 130: object_data := allowed_value_column_object('TWO_PART_FLAG',yn_data);

126: object_data := allowed_value_column_object('SUPPLIER_ENTERABLE_PYMT_FLAG',yn_data);
127: column_test_table_data(24) := object_data;
128: END IF;
129: IF(p_auction_type IN ('REQUEST_FOR_QUOTE','SOLICITATION')) THEN
130: object_data := allowed_value_column_object('TWO_PART_FLAG',yn_data);
131: column_test_table_data(25) := object_data;
132: END IF;
133: allowed_values_table_data := allowed_values_table('BUYER','SUPPLIER','BOTH','NONE');
134: object_data := allowed_value_column_object('PF_TYPE_ALLOWED',allowed_values_table_data);

Line 134: object_data := allowed_value_column_object('PF_TYPE_ALLOWED',allowed_values_table_data);

130: object_data := allowed_value_column_object('TWO_PART_FLAG',yn_data);
131: column_test_table_data(25) := object_data;
132: END IF;
133: allowed_values_table_data := allowed_values_table('BUYER','SUPPLIER','BOTH','NONE');
134: object_data := allowed_value_column_object('PF_TYPE_ALLOWED',allowed_values_table_data);
135: column_test_table_data(26) := object_data;
136: IF(p_contract_type = 'BLANKET') THEN
137: allowed_values_table_data := allowed_values_table('REQUIRED','OPTIONAL','NONE');
138: object_data := allowed_value_column_object('PRICE_BREAK_RESPONSE',allowed_values_table_data);

Line 138: object_data := allowed_value_column_object('PRICE_BREAK_RESPONSE',allowed_values_table_data);

134: object_data := allowed_value_column_object('PF_TYPE_ALLOWED',allowed_values_table_data);
135: column_test_table_data(26) := object_data;
136: IF(p_contract_type = 'BLANKET') THEN
137: allowed_values_table_data := allowed_values_table('REQUIRED','OPTIONAL','NONE');
138: object_data := allowed_value_column_object('PRICE_BREAK_RESPONSE',allowed_values_table_data);
139: column_test_table_data(27) := object_data;
140: END IF;
141: allowed_values_table_data := allowed_values_table('PRICE_BREAKS','QUANTITY_BASED','NONE');
142: object_data := allowed_value_column_object('PRICE_TIERS_INDICATOR',allowed_values_table_data);

Line 142: object_data := allowed_value_column_object('PRICE_TIERS_INDICATOR',allowed_values_table_data);

138: object_data := allowed_value_column_object('PRICE_BREAK_RESPONSE',allowed_values_table_data);
139: column_test_table_data(27) := object_data;
140: END IF;
141: allowed_values_table_data := allowed_values_table('PRICE_BREAKS','QUANTITY_BASED','NONE');
142: object_data := allowed_value_column_object('PRICE_TIERS_INDICATOR',allowed_values_table_data);
143: column_test_table_data(28) := object_data;
144: object_data := allowed_value_column_object('AMENDMENT_FLAG',yn_data);
145: column_test_table_data(29) := object_data;
146: object_data := allowed_value_column_object('AUCTION_PUBLISHED_FLAG',yn_data);

Line 144: object_data := allowed_value_column_object('AMENDMENT_FLAG',yn_data);

140: END IF;
141: allowed_values_table_data := allowed_values_table('PRICE_BREAKS','QUANTITY_BASED','NONE');
142: object_data := allowed_value_column_object('PRICE_TIERS_INDICATOR',allowed_values_table_data);
143: column_test_table_data(28) := object_data;
144: object_data := allowed_value_column_object('AMENDMENT_FLAG',yn_data);
145: column_test_table_data(29) := object_data;
146: object_data := allowed_value_column_object('AUCTION_PUBLISHED_FLAG',yn_data);
147: column_test_table_data(30) := object_data;
148:

Line 146: object_data := allowed_value_column_object('AUCTION_PUBLISHED_FLAG',yn_data);

142: object_data := allowed_value_column_object('PRICE_TIERS_INDICATOR',allowed_values_table_data);
143: column_test_table_data(28) := object_data;
144: object_data := allowed_value_column_object('AMENDMENT_FLAG',yn_data);
145: column_test_table_data(29) := object_data;
146: object_data := allowed_value_column_object('AUCTION_PUBLISHED_FLAG',yn_data);
147: column_test_table_data(30) := object_data;
148:
149: EXCEPTION
150: WHEN OTHERS THEN

Line 159: obj allowed_value_column_object;

155: col IN VARCHAR2,
156: val IN VARCHAR2,
157: ret_val IN OUT NOCOPY VARCHAR2)
158: AS
159: obj allowed_value_column_object;
160:
161: BEGIN
162: FOR i IN 1..column_test_table_data.Count LOOP
163: obj := column_test_table_data(i);