121: and a.attribute_sequence_number = b.sequence_number;
122:
123: begin
124:
125: PON_AUCTION_PKG.SET_SESSION_LANGUAGE(null, USERENV('LANG'));
126:
127: x_auction_id := p_auction_id;
128: x_line_number := p_line_number;
129: x_attr_seq_number := p_attr_seq_number;
135: from pon_auction_headers_all
136: where auction_header_id = x_auction_id;
137:
138:
139: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
136: where auction_header_id = x_auction_id;
137:
138:
139: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
144: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
137:
138:
139: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
144: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
145:
138:
139: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
144: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
145:
146: numFmtMask := fnd_global.nls_numeric_characters;
139: msgAtMost := PON_AUCTION_PKG.getMessage('PON_AUC_AT_MOST');
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
144: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
145:
146: numFmtMask := fnd_global.nls_numeric_characters;
147: -- 'G' corresponds to group separator; 'D' corresponds to decimal separator
140: msgAtLeast := PON_AUCTION_PKG.getMessage('PON_AUC_AT_LEAST');
141: msgOnOrBefore := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_BEFORE');
142: msgOnOrAfter := PON_AUCTION_PKG.getMessage('PON_AUC_ON_OR_AFTER');
143: msgTo := PON_AUCTION_PKG.getMessage('PON_AUC_TO');
144: msgFrom := PON_AUCTION_PKG.getMessage('PON_AUCTS_FROM');
145:
146: numFmtMask := fnd_global.nls_numeric_characters;
147: -- 'G' corresponds to group separator; 'D' corresponds to decimal separator
148: numFmtWithD := 'FM999G999G999G999G999G999G999G999G999G999G999G990D0999999999999';