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.ASO_CONFIG_OPERATIONS_INT_W dependencies on FND_API

Line 16: a number := fnd_api.g_miss_num;

12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CONFIG_OPERATIONS_INT_W';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVQWCB.PLS';
14:
15: FUNCTION rosetta_g_miss_num_map(n number) RETURN number as
16: a number := fnd_api.g_miss_num;
17: b number := 0-1962.0724;
18: BEGIN
19: IF n=a THEN RETURN b; END IF;
20: IF n=b THEN RETURN a; END IF;

Line 26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,

22: END;
23:
24: PROCEDURE Is_Container
25: (p_api_version IN NUMBER := 1 ,
26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,

Line 27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

23:
24: PROCEDURE Is_Container
25: (p_api_version IN NUMBER := 1 ,
26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,

24: PROCEDURE Is_Container
25: (p_api_version IN NUMBER := 1 ,
26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,

25: (p_api_version IN NUMBER := 1 ,
26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,

26: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,

27: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
35: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

28: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
35: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
36: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,

29: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
35: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
36: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
37: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

Line 34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,

30: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
31: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
32: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
34: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
35: x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
36: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
37: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
38: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 76: WHEN FND_API.G_EXC_ERROR

72: Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Is_Container END');
73: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
74:
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR
77: THEN
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: FND_MSG_PUB.Count_And_Get(
80: p_encoded => FND_API.G_FALSE,

Line 78: x_return_status := FND_API.G_RET_STS_ERROR;

74:
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR
77: THEN
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: FND_MSG_PUB.Count_And_Get(
80: p_encoded => FND_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data

Line 80: p_encoded => FND_API.G_FALSE,

76: WHEN FND_API.G_EXC_ERROR
77: THEN
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: FND_MSG_PUB.Count_And_Get(
80: p_encoded => FND_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data
83: );
84: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

82: p_data => x_msg_data
83: );
84: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
85:
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
87: THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Count_And_Get(
90: p_encoded => FND_API.G_FALSE,

Line 88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

84: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
85:
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
87: THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Count_And_Get(
90: p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data

Line 90: p_encoded => FND_API.G_FALSE,

86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
87: THEN
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: FND_MSG_PUB.Count_And_Get(
90: p_encoded => FND_API.G_FALSE,
91: p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: p_data => x_msg_data
93: );
94: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
95: WHEN OTHERS THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
98: THEN
99: FND_MSG_PUB.Add_Exc_Msg(
100: G_PKG_NAME,

Line 105: p_encoded => FND_API.G_FALSE,

101: l_api_name
102: );
103: END IF;
104: FND_MSG_PUB.Count_And_Get(
105: p_encoded => FND_API.G_FALSE,
106: p_count => x_msg_count,
107: p_data => x_msg_data
108: );
109: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,

111:
112: PROCEDURE Get_Contained_Models
113: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
114: p_api_version IN NUMBER := 1 ,
115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,

Line 116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,

112: PROCEDURE Get_Contained_Models
113: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
114: p_api_version IN NUMBER := 1 ,
115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,

113: (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
114: p_api_version IN NUMBER := 1 ,
115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,

114: p_api_version IN NUMBER := 1 ,
115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,

115: p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,

116: p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,

117: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
125: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

Line 122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,

118: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
125: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
126: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,

119: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
120: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
121: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
122: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
123: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
124: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
125: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
126: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127: )

Line 180: WHEN FND_API.G_EXC_ERROR

176:
177: Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Get_Contained_Models END');
178: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR
181: THEN
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR
181: THEN
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data

Line 184: p_encoded => FND_API.G_FALSE,

180: WHEN FND_API.G_EXC_ERROR
181: THEN
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

185: p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
190: THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.G_FALSE,

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: );
188: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
190: THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data

Line 193: p_encoded => FND_API.G_FALSE,

189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
190: THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get(
193: p_encoded => FND_API.G_FALSE,
194: p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: p_data => x_msg_data
196: );
197: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
198: WHEN OTHERS THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg(
203: G_PKG_NAME,

Line 208: p_encoded => FND_API.G_FALSE,

204: l_api_name
205: );
206: END IF;
207: FND_MSG_PUB.Count_And_Get(
208: p_encoded => FND_API.G_FALSE,
209: p_count => x_msg_count,
210: p_data => x_msg_data
211: );
212: ASO_QUOTE_UTIL_PVT.Disable_Debug_Pvt;

Line 219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,

215: PROCEDURE Config_Operations
216: (x_q_quote_header_id OUT NOCOPY NUMBER,
217: x_q_last_update_date OUT NOCOPY DATE,
218: x_q_object_version_number OUT NOCOPY NUMBER,
219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

216: (x_q_quote_header_id OUT NOCOPY NUMBER,
217: x_q_last_update_date OUT NOCOPY DATE,
218: x_q_object_version_number OUT NOCOPY NUMBER,
219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

217: x_q_last_update_date OUT NOCOPY DATE,
218: x_q_object_version_number OUT NOCOPY NUMBER,
219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

218: x_q_object_version_number OUT NOCOPY NUMBER,
219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

219: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

220: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

221: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

222: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

223: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

224: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

225: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,

226: p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

227: p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

228: p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,

Line 233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

229: p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

230: p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,

Line 235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

231: p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

Line 236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,

232: p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,

233: p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

Line 238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,

234: p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,

235: p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

Line 240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,

236: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,

Line 241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,

237: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,

238: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,

Line 243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,

239: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,

240: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,

Line 245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,

241: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,

Line 246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,

242: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

243: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,

244: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

Line 249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,

245: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

Line 250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,

246: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

247: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

248: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

249: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

250: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,

Line 255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

251: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,

Line 256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,

252: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

253: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,

254: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,

255: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

256: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

257: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,

Line 262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

258: p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

Line 263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

259: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

260: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,

261: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,

Line 266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,

262: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,

Line 267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

263: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,

Line 268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

264: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,

Line 269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,

265: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,

Line 270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,

266: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,

Line 271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,

267: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,

Line 272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,

268: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,

Line 273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,

269: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,

Line 274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,

270: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,

Line 275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,

271: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,

272: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

Line 277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,

273: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,

274: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

275: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

276: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,

Line 281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

277: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

278: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

279: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,

280: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

281: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

282: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

283: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

284: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

285: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

286: p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

287: p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

288: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

289: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

290: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

291: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

292: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

293: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

294: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

295: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

296: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

297: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

298: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

299: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,

300: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,

301: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,

302: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

303: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

304: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

305: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

306: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

307: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

308: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

309: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

310: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

311: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

312: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

313: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,

314: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

315: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

316: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,

Line 321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

317: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

318: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

319: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,

320: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

Line 325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

321: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

322: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,

Line 327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

323: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,

Line 328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,

324: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,

325: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,

Line 330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,

326: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,

Line 331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,

327: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,

Line 332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

328: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,

Line 333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,

329: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,

Line 334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,

330: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,

331: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,

332: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,

Line 337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,

333: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,

334: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

335: p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,

336: p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,

337: p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

Line 342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,

338: p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

339: p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

340: p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,

341: p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

342: p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,

Line 347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,

343: p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,

Line 348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

344: p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

345: p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,

Line 350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,

346: p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,

Line 351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,

347: p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

348: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,

Line 353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,

349: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,

350: p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,

Line 355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

351: p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

Line 356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,

352: p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360: p_ql_creation_date IN jtf_date_table := NULL,

Line 357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,

353: p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360: p_ql_creation_date IN jtf_date_table := NULL,
361: p_ql_created_by IN jtf_number_table := NULL,

Line 358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,

354: p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360: p_ql_creation_date IN jtf_date_table := NULL,
361: p_ql_created_by IN jtf_number_table := NULL,
362: p_ql_last_updated_by IN jtf_number_table := NULL,

Line 359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

355: p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
356: p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
357: p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
358: p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
359: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
360: p_ql_creation_date IN jtf_date_table := NULL,
361: p_ql_created_by IN jtf_number_table := NULL,
362: p_ql_last_updated_by IN jtf_number_table := NULL,
363: p_ql_last_update_date IN jtf_date_table := NULL,

Line 434: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

430: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
431: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
432: p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
433: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
434: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_api_version_number IN NUMBER := 1 ,
436: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
437: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
438: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,

Line 436: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,

432: p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
433: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
434: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_api_version_number IN NUMBER := 1 ,
436: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
437: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
438: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
439: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
440: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,

Line 437: p_commit IN VARCHAR2:= FND_API.G_FALSE ,

433: p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
434: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_api_version_number IN NUMBER := 1 ,
436: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
437: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
438: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
439: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
440: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
441: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 438: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,

434: p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
435: p_api_version_number IN NUMBER := 1 ,
436: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
437: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
438: p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
439: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
440: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
441: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: )

Line 715: WHEN FND_API.G_EXC_ERROR

711: Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_Int_W.Config_Operations END');
712: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR
716: THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(
719: p_encoded => FND_API.G_FALSE,

Line 717: x_return_status := FND_API.G_RET_STS_ERROR;

713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR
716: THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(
719: p_encoded => FND_API.G_FALSE,
720: p_count => x_msg_count,
721: p_data => x_msg_data

Line 719: p_encoded => FND_API.G_FALSE,

715: WHEN FND_API.G_EXC_ERROR
716: THEN
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(
719: p_encoded => FND_API.G_FALSE,
720: p_count => x_msg_count,
721: p_data => x_msg_data
722: );
723:

Line 725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

721: p_data => x_msg_data
722: );
723:
724: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
726: THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: FND_MSG_PUB.Count_And_Get(
729: p_encoded => FND_API.G_FALSE,

Line 727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

723:
724: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
726: THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: FND_MSG_PUB.Count_And_Get(
729: p_encoded => FND_API.G_FALSE,
730: p_count => x_msg_count,
731: p_data => x_msg_data

Line 729: p_encoded => FND_API.G_FALSE,

725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
726: THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: FND_MSG_PUB.Count_And_Get(
729: p_encoded => FND_API.G_FALSE,
730: p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

731: p_data => x_msg_data
732: );
733: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;
734: WHEN OTHERS THEN
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.Add_Exc_Msg(
739: G_PKG_NAME,

Line 744: p_encoded => FND_API.G_FALSE,

740: l_api_name
741: );
742: END IF;
743: FND_MSG_PUB.Count_And_Get(
744: p_encoded => FND_API.G_FALSE,
745: p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748: Aso_Quote_Util_Pvt.Disable_Debug_Pvt;

Line 753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,

749: END Config_Operations;
750:
751:
752: FUNCTION Construct_Appl_Param_Rec(
753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,

750:
751:
752: FUNCTION Construct_Appl_Param_Rec(
753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,

751:
752: FUNCTION Construct_Appl_Param_Rec(
753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,

752: FUNCTION Construct_Appl_Param_Rec(
753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
760: )

Line 757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

753: p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
760: )
761: RETURN CZ_API_PUB.appl_param_rec_type

Line 758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,

754: p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
760: )
761: RETURN CZ_API_PUB.appl_param_rec_type
762: IS

Line 759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR

755: p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
756: p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
757: p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
758: p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
759: p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
760: )
761: RETURN CZ_API_PUB.appl_param_rec_type
762: IS
763: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;

Line 768: l_appl_param_rec.config_creation_date := FND_API.G_MISS_DATE;

764: BEGIN
765: ASO_Quote_Util_Pvt.Enable_Debug_Pvt;
766: Aso_Quote_Util_Pvt.debug('Aso_Config_Operations_int_w.Construct_Appl_Param_Rec BEGIN');
767: IF p_ap_config_creation_date = ROSETTA_G_MISTAKE_DATE THEN
768: l_appl_param_rec.config_creation_date := FND_API.G_MISS_DATE;
769: ELSE
770: l_appl_param_rec.config_creation_date := p_ap_config_creation_date;
771: END IF;
772:

Line 774: l_appl_param_rec.config_model_lookup_date := FND_API.G_MISS_DATE;

770: l_appl_param_rec.config_creation_date := p_ap_config_creation_date;
771: END IF;
772:
773: IF p_ap_config_model_lookup_date = ROSETTA_G_MISTAKE_DATE THEN
774: l_appl_param_rec.config_model_lookup_date := FND_API.G_MISS_DATE;
775: ELSE
776: l_appl_param_rec.config_model_lookup_date := p_ap_config_model_lookup_date;
777: END IF;
778:

Line 780: l_appl_param_rec.config_effective_date := FND_API.G_MISS_DATE;

776: l_appl_param_rec.config_model_lookup_date := p_ap_config_model_lookup_date;
777: END IF;
778:
779: IF p_ap_config_effective_date = ROSETTA_G_MISTAKE_DATE THEN
780: l_appl_param_rec.config_effective_date := FND_API.G_MISS_DATE;
781: ELSE
782: l_appl_param_rec.config_effective_date := p_ap_config_effective_date;
783: END IF;
784:

Line 786: l_appl_param_rec.calling_application_id := FND_API.G_MISS_NUM;

782: l_appl_param_rec.config_effective_date := p_ap_config_effective_date;
783: END IF;
784:
785: IF p_ap_calling_application_id = ROSETTA_G_MISS_NUM THEN
786: l_appl_param_rec.calling_application_id := FND_API.G_MISS_NUM;
787: ELSE
788: l_appl_param_rec.calling_application_id := p_ap_calling_application_id;
789: END IF;
790: