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 PON_ATTRIBUTE_SCORES_INTERFACE

Line 47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,

43: TYPE ATTRIBUTE_SCORES
44: IS
45: RECORD
46: (
47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,

Line 48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,

44: IS
45: RECORD
46: (
47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,

Line 49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,

45: RECORD
46: (
47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,

Line 50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,

46: (
47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,

Line 51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,

47: l_BATCH_ID PON_ATTRIBUTE_SCORES_INTERFACE.BATCH_ID%TYPE,
48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,

Line 52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,

48: l_AUCTION_HEADER_ID PON_ATTRIBUTE_SCORES_INTERFACE.AUCTION_HEADER_ID%TYPE ,
49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,

Line 53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,

49: l_LINE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.LINE_NUMBER%TYPE ,
50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,

Line 54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,

50: l_ATTRIBUTE_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.ATTRIBUTE_SEQUENCE_NUMBER%TYPE ,
51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,

Line 55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,

51: l_VALUE PON_ATTRIBUTE_SCORES_INTERFACE.VALUE%TYPE ,
52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,

Line 56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,

52: l_FROM_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.FROM_RANGE%TYPE ,
53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,

Line 57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,

53: l_TO_RANGE PON_ATTRIBUTE_SCORES_INTERFACE.TO_RANGE%TYPE,
54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,

Line 58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,

54: l_SCORE PON_ATTRIBUTE_SCORES_INTERFACE.SCORE%TYPE ,
55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);

Line 59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,

55: l_SEQUENCE_NUMBER PON_ATTRIBUTE_SCORES_INTERFACE.SEQUENCE_NUMBER%TYPE ,
56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);
63:

Line 60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,

56: l_ACTION PON_ATTRIBUTE_SCORES_INTERFACE.ACTION%TYPE,
57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);
63:
64: TYPE neg_header_record IS RECORD

Line 61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,

57: l_CREATION_DATE PON_ATTRIBUTE_SCORES_INTERFACE.CREATION_DATE%TYPE,
58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);
63:
64: TYPE neg_header_record IS RECORD
65: (

Line 62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);

58: l_CREATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.CREATED_BY%TYPE,
59: l_LAST_UPDATE_DATE PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATE_DATE%TYPE,
60: l_LAST_UPDATED_BY PON_ATTRIBUTE_SCORES_INTERFACE.LAST_UPDATED_BY%TYPE,
61: l_interface_header_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_header_id%TYPE,
62: l_interface_line_id PON_ATTRIBUTE_SCORES_INTERFACE.interface_line_id%TYPE);
63:
64: TYPE neg_header_record IS RECORD
65: (
66: auction_header_id pon_auction_Headers_all.auction_header_id%TYPE,

Line 284: p_sequence_number_attr IN pon_attribute_scores_interface.ATTRIBUTE_SEQUENCE_NUMBER%TYPE,

280:
281: PROCEDURE acceptance_values_insert
282: (
283: p_interface_attr_rec1 IN ATTRIBUTES_VALUES_VALIDATION,
284: p_sequence_number_attr IN pon_attribute_scores_interface.ATTRIBUTE_SEQUENCE_NUMBER%TYPE,
285: l_status IN OUT NOCOPY VARCHAR2);
286:
287: PROCEDURE check_range_overlap
288: (