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.PV_PRICE_PVT dependencies on QP_PREQ_GRP

Line 71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

67: l_enrl_req_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
69:
70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

68: l_obj_ver_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
69:
70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

69:
70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;

70:
71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

Line 75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;

71: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

72: G_LiNE_iNDEX_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

73: G_LiNE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

74: G_PRiCiNG_EFFECTiVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

75: G_ACTiVE_DATE_FiRST_TBL QP_PREQ_GRP.DATE_TYPE ;
76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

76: G_ACTiVE_DATE_FiRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

77: G_ACTiVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

78: G_ACTiVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

79: --G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

80: --G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

81: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

82: G_PRiCED_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

83: G_UOM_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

84: G_PRiCED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;

85: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

Line 90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

86: G_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

Line 91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

87: G_PERCENT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

Line 92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;

88: G_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

89: G_UPD_ADJUSTED_UNiT_PRiCE_TBL QP_PREQ_GRP.NUMBER_TYPE;
90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;

90: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

91: G_PRiCE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

92: G_LiNE_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

93: G_PROCESSiNG_ORDER_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;

94: G_ROUNDiNG_FACTOR_TBL QP_PREQ_GRP.PLS_iNTEGER_TYPE;
95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

95: G_ROUNDiNG_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

96: G_QUALiFiERS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

97: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

98: G_PRiCE_LiST_iD_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

99: G_PL_VALiDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

100: G_PRiCE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

101: G_USAGE_PRiCiNG_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

102: G_LiNE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110:

Line 107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;

103: G_PRiCiNG_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110:
111: line_index number := 0;

Line 108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

104: G_PRiCiNG_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110:
111: line_index number := 0;
112: l_line_index number;

Line 109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

105: G_RELATiONSHiP_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
107: G_RLTD_LiNE_DETAiL_iNDEX_tbl QP_PREQ_GRP.NUMBER_TYPE;
108: G_LiNE_QUANTiTY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
109: G_LiNE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110:
111: line_index number := 0;
112: l_line_index number;
113: l_line_id number;

Line 263: PVX_UTiLiTY_PVT.debug_message('QP Version'||QP_PREQ_GRP.GET_VERSiON);

259: PV_ORDER_MGMT_PVT.Order_Debug_On;
260:
261: -- Debug Message
262: IF (PV_DEBUG_HIGH_ON) THEN
263: PVX_UTiLiTY_PVT.debug_message('QP Version'||QP_PREQ_GRP.GET_VERSiON);
264: END IF;
265:
266: QP_PRiCE_REQUEST_CONTEXT.SET_REQUEST_iD();
267:

Line 321: G_PRiCiNG_STATUS_CODE_tbl(line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

317: G_PROCESSED_FLAG_TBL(line_index) := null;
318: G_PRiCE_FLAG_TBL(line_index) := 'Y';
319: G_LiNE_iD_TBL(line_index) := line_index;
320: G_PROCESSiNG_ORDER_TBL(line_index) := null;
321: G_PRiCiNG_STATUS_CODE_tbl(line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
322: G_PRiCiNG_STATUS_TEXT_tbl(line_index) := null;
323: G_ROUNDiNG_FLAG_TBL(line_index) := null;
324: G_ROUNDiNG_FACTOR_TBL(line_index) := null;
325: G_QUALiFiERS_EXiST_FLAG_TBL(line_index) := 'N';

Line 330: G_usage_pricing_type_tbl(line_index) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;

326: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL(line_index) := 'N';
327: G_PRiCE_LiST_iD_TBL(line_index) := null;
328: G_PL_VALiDATED_FLAG_TBL(line_index) := 'N';
329: G_PRiCE_REQUEST_CODE_TBL(line_index) := null;
330: G_usage_pricing_type_tbl(line_index) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;
331: G_LiNE_CATEGORY_tbl(line_index) := null;
332:
333:
334: OE_ORDER_PUB.G_line.inventory_item_id := l_inventory_item_id_tbl(line_index);

Line 375: G_PRiCiNG_STATUS_CODE_tbl(line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

371: G_PROCESSED_FLAG_TBL(line_index) := null;
372: G_PRiCE_FLAG_TBL(line_index) := 'Y';
373: G_LiNE_iD_TBL(line_index) := line_index;
374: G_PROCESSiNG_ORDER_TBL(line_index) := null;
375: G_PRiCiNG_STATUS_CODE_tbl(line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
376: G_PRiCiNG_STATUS_TEXT_tbl(line_index) := null;
377: G_ROUNDiNG_FLAG_TBL(line_index) := null;
378: G_ROUNDiNG_FACTOR_TBL(line_index) := null;
379: G_QUALiFiERS_EXiST_FLAG_TBL(line_index) := 'N';

Line 384: G_usage_pricing_type_tbl(line_index) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;

380: G_PRiCiNG_ATTRS_EXiST_FLAG_TBL(line_index) := 'N';
381: G_PRiCE_LiST_iD_TBL(line_index) := null;
382: G_PL_VALiDATED_FLAG_TBL(line_index) := 'N';
383: G_PRiCE_REQUEST_CODE_TBL(line_index) := null;
384: G_usage_pricing_type_tbl(line_index) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;
385: --G_LiNE_CATEGORY_tbl(line_index) := null;
386:
387: oe_order_pub.g_hdr.transactional_curr_code := p_transaction_currency;
388: oe_order_pub.g_hdr.sold_to_org_id := p_partner_account_id;

Line 405: QP_PREQ_GRP.iNSERT_LiNES2

401: PVX_UTiLiTY_PVT.debug_message('Before inserting into temporary tables');
402: END IF;
403:
404:
405: QP_PREQ_GRP.iNSERT_LiNES2
406: (p_LiNE_iNDEX => G_LiNE_iNDEX_TBL,
407: p_LiNE_TYPE_CODE => G_LiNE_TYPE_CODE_TBL,
408: p_PRiCiNG_EFFECTiVE_DATE => G_PRiCiNG_EFFECTiVE_DATE_TBL,
409: p_ACTiVE_DATE_FiRST => G_ACTiVE_DATE_FiRST_TBL,