71: -- QP Result Record to capture information returned by QP.
72: -- Record to keep the freight charge info per line
73: Type Freight_Charges_Rec_Type is RECORD
74: (
75: charge_type_code QP_PREQ_LDETS_TMP_T.charge_type_code%TYPE,
76: freight_charge QP_PREQ_LDETS_TMP_T.ORDER_QTY_ADJ_AMT%TYPE,
77: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
78: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
79: );
72: -- Record to keep the freight charge info per line
73: Type Freight_Charges_Rec_Type is RECORD
74: (
75: charge_type_code QP_PREQ_LDETS_TMP_T.charge_type_code%TYPE,
76: freight_charge QP_PREQ_LDETS_TMP_T.ORDER_QTY_ADJ_AMT%TYPE,
77: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
78: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
79: );
80:
73: Type Freight_Charges_Rec_Type is RECORD
74: (
75: charge_type_code QP_PREQ_LDETS_TMP_T.charge_type_code%TYPE,
76: freight_charge QP_PREQ_LDETS_TMP_T.ORDER_QTY_ADJ_AMT%TYPE,
77: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
78: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
79: );
80:
81: Type Freight_Charges_Rec_Tbl_Type is table of Freight_Charges_Rec_Type;
74: (
75: charge_type_code QP_PREQ_LDETS_TMP_T.charge_type_code%TYPE,
76: freight_charge QP_PREQ_LDETS_TMP_T.ORDER_QTY_ADJ_AMT%TYPE,
77: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
78: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
79: );
80:
81: Type Freight_Charges_Rec_Tbl_Type is table of Freight_Charges_Rec_Type;
82:
82:
83: --Record to keep the price/charge info per line.
84: Type Qp_Price_Result_Rec_Type is RECORD
85: (
86: line_index QP_PREQ_LDETS_TMP_T.line_index%TYPE,
87: line_id NUMBER,
88: base_unit_price NUMBER,
89: adjusted_price NUMBER,
90: freight_charge_rec_tbl freight_charges_rec_tbl_type,
87: line_id NUMBER,
88: base_unit_price NUMBER,
89: adjusted_price NUMBER,
90: freight_charge_rec_tbl freight_charges_rec_tbl_type,
91: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
92: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
93: );
94:
95: Type Qp_Price_Result_Rec_Tbl_Type is table of Qp_Price_Result_Rec_Type;
88: base_unit_price NUMBER,
89: adjusted_price NUMBER,
90: freight_charge_rec_tbl freight_charges_rec_tbl_type,
91: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,
92: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%TYPE
93: );
94:
95: Type Qp_Price_Result_Rec_Tbl_Type is table of Qp_Price_Result_Rec_Type;
96: