DBA Data[Home] [Help]

APPS.PO_ADVANCED_PRICE_PVT dependencies on QP_PREQ_LDETS_TMP_T

Line 75: charge_type_code QP_PREQ_LDETS_TMP_T.charge_type_code%TYPE,

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: );

Line 76: freight_charge QP_PREQ_LDETS_TMP_T.ORDER_QTY_ADJ_AMT%TYPE,

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:

Line 77: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%TYPE,

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;

Line 78: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%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:

Line 86: line_index QP_PREQ_LDETS_TMP_T.line_index%TYPE,

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,

Line 91: pricing_status_code QP_PREQ_LDETS_TMP_T.pricing_status_code%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;

Line 92: pricing_status_text QP_PREQ_LDETS_TMP_T.pricing_status_text%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: