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.FTE_RATE_CHART_PKG dependencies on QP_INTERFACE_LIST_LINES

Line 21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,

17: qp_list_header_rec
18: INDEX BY BINARY_INTEGER;
19:
20: TYPE qp_list_line_rec IS RECORD (
21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,
22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,

Line 22: OPERAND qp_interface_list_lines.operand%TYPE,

18: INDEX BY BINARY_INTEGER;
19:
20: TYPE qp_list_line_rec IS RECORD (
21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,
22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,

Line 23: COMMENTS qp_interface_list_lines.comments%TYPE,

19:
20: TYPE qp_list_line_rec IS RECORD (
21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,
22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,

Line 24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,

20: TYPE qp_list_line_rec IS RECORD (
21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,
22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,

Line 25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,

21: PROCESS_ID qp_interface_list_lines.process_id%TYPE,
22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,

Line 26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,

22: OPERAND qp_interface_list_lines.operand%TYPE,
23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,

Line 27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,

23: COMMENTS qp_interface_list_lines.comments%TYPE,
24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,

Line 28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,

24: LIST_LINE_NO qp_interface_list_lines.list_line_no%TYPE,
25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,

Line 29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,

25: PRIMARY_UOM_FLAG qp_interface_list_lines.primary_uom_flag%TYPE,
26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,

Line 30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,

26: PROCESS_TYPE qp_interface_list_lines.process_type%TYPE,
27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,

Line 31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,

27: INTERFACE_ACTION_CODE qp_interface_list_lines.interface_action_code%TYPE,
28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,

Line 32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,

28: LIST_LINE_TYPE_CODE qp_interface_list_lines.list_line_type_code%TYPE,
29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,

Line 33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,

29: AUTOMATIC_FLAG qp_interface_list_lines.automatic_flag%TYPE,
30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,

Line 34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,

30: OVERRIDE_FLAG qp_interface_list_lines.override_flag%TYPE,
31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,

Line 35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,

31: MODIFIER_LEVEL_CODE qp_interface_list_lines.modifier_level_code%TYPE,
32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,

Line 36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,

32: ARITHMETIC_OPERATOR qp_interface_list_lines.arithmetic_operator%TYPE,
33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,

Line 37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,

33: ACCRUAL_FLAG qp_interface_list_lines.accrual_flag%TYPE,
34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,

Line 38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,

34: PRICE_BREAK_TYPE_CODE qp_interface_list_lines.price_break_type_code%TYPE,
35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,

Line 39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,

35: PRODUCT_PRECEDENCE qp_interface_list_lines.product_precedence%TYPE,
36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,

Line 40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,

36: PRICE_BREAK_HEADER_INDEX qp_interface_list_lines.price_break_header_index%TYPE,
37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,

Line 41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,

37: RLTD_MODIFIER_GRP_NO qp_interface_list_lines.rltd_modifier_grp_no%TYPE,
38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,

Line 42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,

38: PRICE_BY_FORMULA_ID qp_interface_list_lines.price_by_formula_id%TYPE,
39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,

Line 43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,

39: ATTRIBUTE1 qp_interface_list_lines.attribute1%TYPE,
40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,

Line 44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,

40: ATTRIBUTE2 qp_interface_list_lines.attribute2%TYPE,
41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,
48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);

Line 45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,

41: RLTD_MODIFIER_GRP_TYPE qp_interface_list_lines.rltd_modifier_grp_type%TYPE,
42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,
48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);
49:

Line 46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,

42: PRICING_GROUP_SEQUENCE qp_interface_list_lines.pricing_group_sequence%TYPE,
43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,
48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);
49:
50: TYPE qp_list_line_tbl IS TABLE OF

Line 47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,

43: PRICING_PHASE_ID qp_interface_list_lines.pricing_phase_id%TYPE,
44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,
48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);
49:
50: TYPE qp_list_line_tbl IS TABLE OF
51: qp_list_line_rec

Line 48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);

44: QUALIFICATION_IND qp_interface_list_lines.qualification_ind%TYPE,
45: CHARGE_TYPE_CODE qp_interface_list_lines.charge_type_code%TYPE,
46: CHARGE_SUBTYPE_CODE qp_interface_list_lines.charge_subtype_code%TYPE,
47: START_DATE_ACTIVE qp_interface_list_lines.start_date_active%TYPE,
48: END_DATE_ACTIVE qp_interface_list_lines.end_date_active%TYPE);
49:
50: TYPE qp_list_line_tbl IS TABLE OF
51: qp_list_line_rec
52: INDEX BY BINARY_INTEGER;

Line 204: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,

200: -----------------------------------------------------------------------------
201: -- PROCEDURE: INSERT_QP_INTERFACE_TABLES
202: --
203: -- Purpose: Transfer pricelist data from the temporary tables in memory into
204: -- QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES,
205: -- QP_INTERFACE_QUALIFIERS and QP_INTERFACE_PRICING_ATTRIBS.
206: -- If input parameter 'p_job_id' IS NOT NULL, then the QP api
207: -- QP_PRL_LOADER_PUB(...) is also used to load the rate chart for
208: -- that particular job id. Otherwise, the data might correspond to