[Home] [Help]
10: ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724;
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_QUOTE_W2_PVT';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVQW2B.PLS';
14: l_true VARCHAR2(1) := FND_API.G_TRUE;
15:
16: PROCEDURE set_control_rec_w(
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'IBEVQW2B.PLS';
14: l_true VARCHAR2(1) := FND_API.G_TRUE;
15:
16: PROCEDURE set_control_rec_w(
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
14: l_true VARCHAR2(1) := FND_API.G_TRUE;
15:
16: PROCEDURE set_control_rec_w(
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
15:
16: PROCEDURE set_control_rec_w(
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
16: PROCEDURE set_control_rec_w(
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
24: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
17: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
24: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
25: )
18: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
24: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
25: )
26: IS
19: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
24: x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
25: )
26: IS
27: BEGIN
25: )
26: IS
27: BEGIN
28: IF p_c_last_update_date <> ROSETTA_G_MISTAKE_DATE
29: AND p_c_last_update_date <> FND_API.G_MISS_DATE
30: AND p_c_last_update_date <> null THEN
31: x_control_rec.last_update_date := p_c_last_update_date;
32: END IF;
33:
30: AND p_c_last_update_date <> null THEN
31: x_control_rec.last_update_date := p_c_last_update_date;
32: END IF;
33:
34: IF p_c_auto_version_flag <> FND_API.G_MISS_CHAR THEN
35: x_control_rec.auto_version_flag := p_c_auto_version_flag;
36: END IF;
37:
38: IF p_c_pricing_request_type <> FND_API.G_MISS_CHAR THEN
34: IF p_c_auto_version_flag <> FND_API.G_MISS_CHAR THEN
35: x_control_rec.auto_version_flag := p_c_auto_version_flag;
36: END IF;
37:
38: IF p_c_pricing_request_type <> FND_API.G_MISS_CHAR THEN
39: x_control_rec.pricing_request_type := p_c_pricing_request_type;
40: END IF;
41:
42: IF p_c_header_pricing_event <> FND_API.G_MISS_CHAR THEN
38: IF p_c_pricing_request_type <> FND_API.G_MISS_CHAR THEN
39: x_control_rec.pricing_request_type := p_c_pricing_request_type;
40: END IF;
41:
42: IF p_c_header_pricing_event <> FND_API.G_MISS_CHAR THEN
43: x_control_rec.header_pricing_event := p_c_header_pricing_event;
44: END IF;
45:
46: IF p_c_line_pricing_event <> FND_API.G_MISS_CHAR THEN
42: IF p_c_header_pricing_event <> FND_API.G_MISS_CHAR THEN
43: x_control_rec.header_pricing_event := p_c_header_pricing_event;
44: END IF;
45:
46: IF p_c_line_pricing_event <> FND_API.G_MISS_CHAR THEN
47: x_control_rec.line_pricing_event := p_c_line_pricing_event;
48: END IF;
49:
50: IF p_c_cal_tax_flag <> FND_API.G_MISS_CHAR THEN
46: IF p_c_line_pricing_event <> FND_API.G_MISS_CHAR THEN
47: x_control_rec.line_pricing_event := p_c_line_pricing_event;
48: END IF;
49:
50: IF p_c_cal_tax_flag <> FND_API.G_MISS_CHAR THEN
51: x_control_rec.calculate_tax_flag := p_c_cal_tax_flag;
52: END IF;
53:
54: IF p_c_cal_freight_charge_flag <> FND_API.G_MISS_CHAR THEN
50: IF p_c_cal_tax_flag <> FND_API.G_MISS_CHAR THEN
51: x_control_rec.calculate_tax_flag := p_c_cal_tax_flag;
52: END IF;
53:
54: IF p_c_cal_freight_charge_flag <> FND_API.G_MISS_CHAR THEN
55: x_control_rec.calculate_freight_charge_flag := p_c_cal_freight_charge_flag;
56: END IF;
57: END Set_Control_Rec_W;
58:
56: END IF;
57: END Set_Control_Rec_W;
58:
59: PROCEDURE set_saveshare2_control_rec_w(
60: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
57: END Set_Control_Rec_W;
58:
59: PROCEDURE set_saveshare2_control_rec_w(
60: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
58:
59: PROCEDURE set_saveshare2_control_rec_w(
60: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
59: PROCEDURE set_saveshare2_control_rec_w(
60: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
60: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
61: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
62: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
71: x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
64: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
71: x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
72: ) is
65: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
71: x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
72: ) is
73:
66: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
67: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
68: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
69: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
70: p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
71: x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
72: ) is
73:
74: l_control_rec ASO_QUOTE_PUB.control_rec_type;
314: IF l_table_size > 0 THEN
315: FOR i IN 1..l_table_size LOOP
316: l_sales_credit_tbl(i).operation_code := p_operation_code(i);
317: IF p_qte_line_index(i)= ROSETTA_G_MISS_NUM THEN
318: l_sales_credit_tbl(i).qte_line_index := FND_API.G_MISS_NUM;
319: ELSE
320: l_sales_credit_tbl(i).qte_line_index := p_qte_line_index(i);
321: END IF;
322: IF p_sales_credit_id(i)= ROSETTA_G_MISS_NUM THEN
319: ELSE
320: l_sales_credit_tbl(i).qte_line_index := p_qte_line_index(i);
321: END IF;
322: IF p_sales_credit_id(i)= ROSETTA_G_MISS_NUM THEN
323: l_sales_credit_tbl(i).sales_credit_id := FND_API.G_MISS_NUM;
324: ELSE
325: l_sales_credit_tbl(i).sales_credit_id := p_sales_credit_id(i);
326: END IF;
327: IF p_creation_date(i)= ROSETTA_G_MISTAKE_DATE THEN
324: ELSE
325: l_sales_credit_tbl(i).sales_credit_id := p_sales_credit_id(i);
326: END IF;
327: IF p_creation_date(i)= ROSETTA_G_MISTAKE_DATE THEN
328: l_sales_credit_tbl(i).creation_date := FND_API.G_MISS_DATE;
329: ELSE
330: l_sales_credit_tbl(i).creation_date := p_creation_date(i);
331: END IF;
332: IF p_created_by(i)= ROSETTA_G_MISS_NUM THEN
329: ELSE
330: l_sales_credit_tbl(i).creation_date := p_creation_date(i);
331: END IF;
332: IF p_created_by(i)= ROSETTA_G_MISS_NUM THEN
333: l_sales_credit_tbl(i).created_by := FND_API.G_MISS_NUM;
334: ELSE
335: l_sales_credit_tbl(i).created_by := p_created_by(i);
336: END IF;
337: IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
334: ELSE
335: l_sales_credit_tbl(i).created_by := p_created_by(i);
336: END IF;
337: IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
338: l_sales_credit_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
339: ELSE
340: l_sales_credit_tbl(i).last_updated_by := p_last_updated_by(i);
341: END IF;
342: IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
339: ELSE
340: l_sales_credit_tbl(i).last_updated_by := p_last_updated_by(i);
341: END IF;
342: IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
343: l_sales_credit_tbl(i).last_update_date := FND_API.G_MISS_DATE;
344: ELSE
345: l_sales_credit_tbl(i).last_update_date := p_last_update_date(i);
346: END IF;
347: IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
344: ELSE
345: l_sales_credit_tbl(i).last_update_date := p_last_update_date(i);
346: END IF;
347: IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
348: l_sales_credit_tbl(i).last_update_login := FND_API.G_MISS_NUM;
349: ELSE
350: l_sales_credit_tbl(i).last_update_login := p_last_update_login(i);
351: END IF;
352: IF p_request_id(i)= ROSETTA_G_MISS_NUM THEN
349: ELSE
350: l_sales_credit_tbl(i).last_update_login := p_last_update_login(i);
351: END IF;
352: IF p_request_id(i)= ROSETTA_G_MISS_NUM THEN
353: l_sales_credit_tbl(i).request_id := FND_API.G_MISS_NUM;
354: ELSE
355: l_sales_credit_tbl(i).request_id := p_request_id(i);
356: END IF;
357: IF p_program_application_id(i)= ROSETTA_G_MISS_NUM THEN
354: ELSE
355: l_sales_credit_tbl(i).request_id := p_request_id(i);
356: END IF;
357: IF p_program_application_id(i)= ROSETTA_G_MISS_NUM THEN
358: l_sales_credit_tbl(i).program_application_id := FND_API.G_MISS_NUM;
359: ELSE
360: l_sales_credit_tbl(i).program_application_id := p_program_application_id(i);
361: END IF;
362: IF p_program_id(i)= ROSETTA_G_MISS_NUM THEN
359: ELSE
360: l_sales_credit_tbl(i).program_application_id := p_program_application_id(i);
361: END IF;
362: IF p_program_id(i)= ROSETTA_G_MISS_NUM THEN
363: l_sales_credit_tbl(i).program_id := FND_API.G_MISS_NUM;
364: ELSE
365: l_sales_credit_tbl(i).program_id := p_program_id(i);
366: END IF;
367: IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
364: ELSE
365: l_sales_credit_tbl(i).program_id := p_program_id(i);
366: END IF;
367: IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
368: l_sales_credit_tbl(i).program_update_date := FND_API.G_MISS_DATE;
369: ELSE
370: l_sales_credit_tbl(i).program_update_date := p_program_update_date(i);
371: END IF;
372: IF p_quote_header_id(i)= ROSETTA_G_MISS_NUM THEN
369: ELSE
370: l_sales_credit_tbl(i).program_update_date := p_program_update_date(i);
371: END IF;
372: IF p_quote_header_id(i)= ROSETTA_G_MISS_NUM THEN
373: l_sales_credit_tbl(i).quote_header_id := FND_API.G_MISS_NUM;
374: ELSE
375: l_sales_credit_tbl(i).quote_header_id := p_quote_header_id(i);
376: END IF;
377: IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
374: ELSE
375: l_sales_credit_tbl(i).quote_header_id := p_quote_header_id(i);
376: END IF;
377: IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
378: l_sales_credit_tbl(i).quote_line_id := FND_API.G_MISS_NUM;
379: ELSE
380: l_sales_credit_tbl(i).quote_line_id := p_quote_line_id(i);
381: END IF;
382: IF p_percent(i)= ROSETTA_G_MISS_NUM THEN
379: ELSE
380: l_sales_credit_tbl(i).quote_line_id := p_quote_line_id(i);
381: END IF;
382: IF p_percent(i)= ROSETTA_G_MISS_NUM THEN
383: l_sales_credit_tbl(i).percent := FND_API.G_MISS_NUM;
384: ELSE
385: l_sales_credit_tbl(i).percent := p_percent(i);
386: END IF;
387: IF p_resource_id(i)= ROSETTA_G_MISS_NUM THEN
384: ELSE
385: l_sales_credit_tbl(i).percent := p_percent(i);
386: END IF;
387: IF p_resource_id(i)= ROSETTA_G_MISS_NUM THEN
388: l_sales_credit_tbl(i).resource_id := FND_API.G_MISS_NUM;
389: ELSE
390: l_sales_credit_tbl(i).resource_id := p_resource_id(i);
391: END IF;
392:
392:
393: l_sales_credit_tbl(i).sales_credit_type := p_sales_credit_type(i);
394:
395: IF p_resource_group_id(i)= ROSETTA_G_MISS_NUM THEN
396: l_sales_credit_tbl(i).resource_group_id := FND_API.G_MISS_NUM;
397: ELSE
398: l_sales_credit_tbl(i).resource_group_id := p_resource_group_id(i);
399: END IF;
400: IF p_employee_person_id(i)= ROSETTA_G_MISS_NUM THEN
397: ELSE
398: l_sales_credit_tbl(i).resource_group_id := p_resource_group_id(i);
399: END IF;
400: IF p_employee_person_id(i)= ROSETTA_G_MISS_NUM THEN
401: l_sales_credit_tbl(i).employee_person_id := FND_API.G_MISS_NUM;
402: ELSE
403: l_sales_credit_tbl(i).employee_person_id := p_employee_person_id(i);
404: END IF;
405: IF p_sales_credit_type_id(i)= ROSETTA_G_MISS_NUM THEN
402: ELSE
403: l_sales_credit_tbl(i).employee_person_id := p_employee_person_id(i);
404: END IF;
405: IF p_sales_credit_type_id(i)= ROSETTA_G_MISS_NUM THEN
406: l_sales_credit_tbl(i).sales_credit_type_id := FND_API.G_MISS_NUM;
407: ELSE
408: l_sales_credit_tbl(i).sales_credit_type_id := p_sales_credit_type_id(i);
409: END IF;
410:
432: END IF;
433: END Construct_Sales_Credit_Tbl;
434:
435: FUNCTION construct_qte_header_rec(
436: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
433: END Construct_Sales_Credit_Tbl;
434:
435: FUNCTION construct_qte_header_rec(
436: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
434:
435: FUNCTION construct_qte_header_rec(
436: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
435: FUNCTION construct_qte_header_rec(
436: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
436: p_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
437: p_creation_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
438: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
439: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
440: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
441: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
442: p_request_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
443: p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
444: p_program_id IN NUMBER := FND_API.G_MISS_NUM,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
445: p_program_update_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
446: p_org_id IN NUMBER := FND_API.G_MISS_NUM,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
447: p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
448: p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
449: p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
450: p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
451: p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
452: p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
453: p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
454: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
455: p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
456: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
457: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
458: p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
459: p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
460: p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
461: p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
462: p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
463: p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
464: p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
465: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
466: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
467: p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
468: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
469: p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
471: p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
472: p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
473: p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
474: p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
475: p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
476: p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
477: p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
478: p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
479: p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
480: p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
481: p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
482: p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
483: p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
484: p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
485: p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
486: -- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
487: p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
488: -- bug 6873117 mgiridha added attribute 16-20
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
489: p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
490: p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
491: p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
492: p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
493: p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
494: p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
495: p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
496: p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
497: p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
498: p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
499: p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
500: p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
501: p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
502: p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
503: p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
504: p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
505: p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
506: p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
509: p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
510: p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
511: p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
512: p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
513: p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
514: p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
515: p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
516: p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
517: p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
518: p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
519: p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
520: p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
524: p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
527: p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
528: p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
529: p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
530: p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
531: p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
532: p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
533: p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
534: p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
542: )
535: p_order_id IN NUMBER := FND_API.G_MISS_NUM,
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
542: )
543: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
536: p_order_number IN NUMBER := FND_API.G_MISS_NUM,
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
542: )
543: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
544: IS
537: p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
538: p_ordered_date IN DATE := FND_API.G_MISS_DATE,
539: p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
540: p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
541: p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
542: )
543: RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
544: IS
545: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
544: IS
545: l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
546: BEGIN
547: IF p_quote_header_id= ROSETTA_G_MISS_NUM THEN
548: l_qte_header.quote_header_id := FND_API.G_MISS_NUM;
549: ELSE
550: l_qte_header.quote_header_id := p_quote_header_id;
551: END IF;
552: IF p_creation_date= ROSETTA_G_MISTAKE_DATE THEN
549: ELSE
550: l_qte_header.quote_header_id := p_quote_header_id;
551: END IF;
552: IF p_creation_date= ROSETTA_G_MISTAKE_DATE THEN
553: l_qte_header.creation_date := FND_API.G_MISS_DATE;
554: ELSE
555: l_qte_header.creation_date := p_creation_date;
556: END IF;
557: IF p_created_by= ROSETTA_G_MISS_NUM THEN
554: ELSE
555: l_qte_header.creation_date := p_creation_date;
556: END IF;
557: IF p_created_by= ROSETTA_G_MISS_NUM THEN
558: l_qte_header.created_by := FND_API.G_MISS_NUM;
559: ELSE
560: l_qte_header.created_by := p_created_by;
561: END IF;
562: IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
559: ELSE
560: l_qte_header.created_by := p_created_by;
561: END IF;
562: IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
563: l_qte_header.last_updated_by := FND_API.G_MISS_NUM;
564: ELSE
565: l_qte_header.last_updated_by := p_last_updated_by;
566: END IF;
567: IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
564: ELSE
565: l_qte_header.last_updated_by := p_last_updated_by;
566: END IF;
567: IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
568: l_qte_header.last_update_date := FND_API.G_MISS_DATE;
569: ELSE
570: l_qte_header.last_update_date := p_last_update_date;
571: END IF;
572: IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
569: ELSE
570: l_qte_header.last_update_date := p_last_update_date;
571: END IF;
572: IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
573: l_qte_header.last_update_login := FND_API.G_MISS_NUM;
574: ELSE
575: l_qte_header.last_update_login := p_last_update_login;
576: END IF;
577: IF p_request_id= ROSETTA_G_MISS_NUM THEN
574: ELSE
575: l_qte_header.last_update_login := p_last_update_login;
576: END IF;
577: IF p_request_id= ROSETTA_G_MISS_NUM THEN
578: l_qte_header.request_id := FND_API.G_MISS_NUM;
579: ELSE
580: l_qte_header.request_id := p_request_id;
581: END IF;
582: IF p_program_application_id= ROSETTA_G_MISS_NUM THEN
579: ELSE
580: l_qte_header.request_id := p_request_id;
581: END IF;
582: IF p_program_application_id= ROSETTA_G_MISS_NUM THEN
583: l_qte_header.program_application_id := FND_API.G_MISS_NUM;
584: ELSE
585: l_qte_header.program_application_id := p_program_application_id;
586: END IF;
587: IF p_program_id= ROSETTA_G_MISS_NUM THEN
584: ELSE
585: l_qte_header.program_application_id := p_program_application_id;
586: END IF;
587: IF p_program_id= ROSETTA_G_MISS_NUM THEN
588: l_qte_header.program_id := FND_API.G_MISS_NUM;
589: ELSE
590: l_qte_header.program_id := p_program_id;
591: END IF;
592: IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
589: ELSE
590: l_qte_header.program_id := p_program_id;
591: END IF;
592: IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
593: l_qte_header.program_update_date := FND_API.G_MISS_DATE;
594: ELSE
595: l_qte_header.program_update_date := p_program_update_date;
596: END IF;
597: IF p_org_id= ROSETTA_G_MISS_NUM THEN
594: ELSE
595: l_qte_header.program_update_date := p_program_update_date;
596: END IF;
597: IF p_org_id= ROSETTA_G_MISS_NUM THEN
598: l_qte_header.org_id := FND_API.G_MISS_NUM;
599: ELSE
600: l_qte_header.org_id := p_org_id;
601: END IF;
602: l_qte_header.quote_name := p_quote_name;
600: l_qte_header.org_id := p_org_id;
601: END IF;
602: l_qte_header.quote_name := p_quote_name;
603: IF p_quote_number= ROSETTA_G_MISS_NUM THEN
604: l_qte_header.quote_number := FND_API.G_MISS_NUM;
605: ELSE
606: l_qte_header.quote_number := p_quote_number;
607: END IF;
608: IF p_quote_version= ROSETTA_G_MISS_NUM THEN
605: ELSE
606: l_qte_header.quote_number := p_quote_number;
607: END IF;
608: IF p_quote_version= ROSETTA_G_MISS_NUM THEN
609: l_qte_header.quote_version := FND_API.G_MISS_NUM;
610: ELSE
611: l_qte_header.quote_version := p_quote_version;
612: END IF;
613: IF p_quote_status_id= ROSETTA_G_MISS_NUM THEN
610: ELSE
611: l_qte_header.quote_version := p_quote_version;
612: END IF;
613: IF p_quote_status_id= ROSETTA_G_MISS_NUM THEN
614: l_qte_header.quote_status_id := FND_API.G_MISS_NUM;
615: ELSE
616: l_qte_header.quote_status_id := p_quote_status_id;
617: END IF;
618: l_qte_header.quote_source_code := p_quote_source_code;
616: l_qte_header.quote_status_id := p_quote_status_id;
617: END IF;
618: l_qte_header.quote_source_code := p_quote_source_code;
619: IF p_quote_expiration_date= ROSETTA_G_MISTAKE_DATE THEN
620: l_qte_header.quote_expiration_date := FND_API.G_MISS_DATE;
621: ELSE
622: l_qte_header.quote_expiration_date := p_quote_expiration_date;
623: END IF;
624: IF p_price_frozen_date= ROSETTA_G_MISTAKE_DATE THEN
621: ELSE
622: l_qte_header.quote_expiration_date := p_quote_expiration_date;
623: END IF;
624: IF p_price_frozen_date= ROSETTA_G_MISTAKE_DATE THEN
625: l_qte_header.price_frozen_date := FND_API.G_MISS_DATE;
626: ELSE
627: l_qte_header.price_frozen_date := p_price_frozen_date;
628: END IF;
629: l_qte_header.quote_password := p_quote_password;
628: END IF;
629: l_qte_header.quote_password := p_quote_password;
630: l_qte_header.original_system_reference := p_original_system_reference;
631: IF p_party_id= ROSETTA_G_MISS_NUM THEN
632: l_qte_header.party_id := FND_API.G_MISS_NUM;
633: ELSE
634: l_qte_header.party_id := p_party_id;
635: END IF;
636: IF p_cust_account_id= ROSETTA_G_MISS_NUM THEN
633: ELSE
634: l_qte_header.party_id := p_party_id;
635: END IF;
636: IF p_cust_account_id= ROSETTA_G_MISS_NUM THEN
637: l_qte_header.cust_account_id := FND_API.G_MISS_NUM;
638: ELSE
639: l_qte_header.cust_account_id := p_cust_account_id;
640: END IF;
641: IF p_invoice_to_cust_account_id= ROSETTA_G_MISS_NUM THEN
638: ELSE
639: l_qte_header.cust_account_id := p_cust_account_id;
640: END IF;
641: IF p_invoice_to_cust_account_id= ROSETTA_G_MISS_NUM THEN
642: l_qte_header.invoice_to_cust_account_id := FND_API.G_MISS_NUM;
643: ELSE
644: l_qte_header.invoice_to_cust_account_id := p_invoice_to_cust_account_id;
645: END IF;
646: IF p_org_contact_id= ROSETTA_G_MISS_NUM THEN
643: ELSE
644: l_qte_header.invoice_to_cust_account_id := p_invoice_to_cust_account_id;
645: END IF;
646: IF p_org_contact_id= ROSETTA_G_MISS_NUM THEN
647: l_qte_header.org_contact_id := FND_API.G_MISS_NUM;
648: ELSE
649: l_qte_header.org_contact_id := p_org_contact_id;
650: END IF;
651: l_qte_header.party_name := p_party_name;
653: l_qte_header.person_first_name := p_person_first_name;
654: l_qte_header.person_last_name := p_person_last_name;
655: l_qte_header.person_middle_name := p_person_middle_name;
656: IF p_phone_id= ROSETTA_G_MISS_NUM THEN
657: l_qte_header.phone_id := FND_API.G_MISS_NUM;
658: ELSE
659: l_qte_header.phone_id := p_phone_id;
660: END IF;
661: IF p_price_list_id= ROSETTA_G_MISS_NUM THEN
658: ELSE
659: l_qte_header.phone_id := p_phone_id;
660: END IF;
661: IF p_price_list_id= ROSETTA_G_MISS_NUM THEN
662: l_qte_header.price_list_id := FND_API.G_MISS_NUM;
663: ELSE
664: l_qte_header.price_list_id := p_price_list_id;
665: END IF;
666: l_qte_header.price_list_name := p_price_list_name;
665: END IF;
666: l_qte_header.price_list_name := p_price_list_name;
667: l_qte_header.currency_code := p_currency_code;
668: IF p_total_list_price= ROSETTA_G_MISS_NUM THEN
669: l_qte_header.total_list_price := FND_API.G_MISS_NUM;
670: ELSE
671: l_qte_header.total_list_price := p_total_list_price;
672: END IF;
673: IF p_total_adjusted_amount= ROSETTA_G_MISS_NUM THEN
670: ELSE
671: l_qte_header.total_list_price := p_total_list_price;
672: END IF;
673: IF p_total_adjusted_amount= ROSETTA_G_MISS_NUM THEN
674: l_qte_header.total_adjusted_amount := FND_API.G_MISS_NUM;
675: ELSE
676: l_qte_header.total_adjusted_amount := p_total_adjusted_amount;
677: END IF;
678: IF p_total_adjusted_percent= ROSETTA_G_MISS_NUM THEN
675: ELSE
676: l_qte_header.total_adjusted_amount := p_total_adjusted_amount;
677: END IF;
678: IF p_total_adjusted_percent= ROSETTA_G_MISS_NUM THEN
679: l_qte_header.total_adjusted_percent := FND_API.G_MISS_NUM;
680: ELSE
681: l_qte_header.total_adjusted_percent := p_total_adjusted_percent;
682: END IF;
683: IF p_total_tax= ROSETTA_G_MISS_NUM THEN
680: ELSE
681: l_qte_header.total_adjusted_percent := p_total_adjusted_percent;
682: END IF;
683: IF p_total_tax= ROSETTA_G_MISS_NUM THEN
684: l_qte_header.total_tax := FND_API.G_MISS_NUM;
685: ELSE
686: l_qte_header.total_tax := p_total_tax;
687: END IF;
688: IF p_total_shipping_charge= ROSETTA_G_MISS_NUM THEN
685: ELSE
686: l_qte_header.total_tax := p_total_tax;
687: END IF;
688: IF p_total_shipping_charge= ROSETTA_G_MISS_NUM THEN
689: l_qte_header.total_shipping_charge := FND_API.G_MISS_NUM;
690: ELSE
691: l_qte_header.total_shipping_charge := p_total_shipping_charge;
692: END IF;
693: IF p_surcharge= ROSETTA_G_MISS_NUM THEN
690: ELSE
691: l_qte_header.total_shipping_charge := p_total_shipping_charge;
692: END IF;
693: IF p_surcharge= ROSETTA_G_MISS_NUM THEN
694: l_qte_header.surcharge := FND_API.G_MISS_NUM;
695: ELSE
696: l_qte_header.surcharge := p_surcharge;
697: END IF;
698: IF p_total_quote_price= ROSETTA_G_MISS_NUM THEN
695: ELSE
696: l_qte_header.surcharge := p_surcharge;
697: END IF;
698: IF p_total_quote_price= ROSETTA_G_MISS_NUM THEN
699: l_qte_header.total_quote_price := FND_API.G_MISS_NUM;
700: ELSE
701: l_qte_header.total_quote_price := p_total_quote_price;
702: END IF;
703: IF p_payment_amount= ROSETTA_G_MISS_NUM THEN
700: ELSE
701: l_qte_header.total_quote_price := p_total_quote_price;
702: END IF;
703: IF p_payment_amount= ROSETTA_G_MISS_NUM THEN
704: l_qte_header.payment_amount := FND_API.G_MISS_NUM;
705: ELSE
706: l_qte_header.payment_amount := p_payment_amount;
707: END IF;
708: IF p_accounting_rule_id= ROSETTA_G_MISS_NUM THEN
705: ELSE
706: l_qte_header.payment_amount := p_payment_amount;
707: END IF;
708: IF p_accounting_rule_id= ROSETTA_G_MISS_NUM THEN
709: l_qte_header.accounting_rule_id := FND_API.G_MISS_NUM;
710: ELSE
711: l_qte_header.accounting_rule_id := p_accounting_rule_id;
712: END IF;
713: IF p_exchange_rate= ROSETTA_G_MISS_NUM THEN
710: ELSE
711: l_qte_header.accounting_rule_id := p_accounting_rule_id;
712: END IF;
713: IF p_exchange_rate= ROSETTA_G_MISS_NUM THEN
714: l_qte_header.exchange_rate := FND_API.G_MISS_NUM;
715: ELSE
716: l_qte_header.exchange_rate := p_exchange_rate;
717: END IF;
718: l_qte_header.exchange_type_code := p_exchange_type_code;
716: l_qte_header.exchange_rate := p_exchange_rate;
717: END IF;
718: l_qte_header.exchange_type_code := p_exchange_type_code;
719: IF p_exchange_rate_date= ROSETTA_G_MISTAKE_DATE THEN
720: l_qte_header.exchange_rate_date := FND_API.G_MISS_DATE;
721: ELSE
722: l_qte_header.exchange_rate_date := p_exchange_rate_date;
723: END IF;
724: l_qte_header.quote_category_code := p_quote_category_code;
724: l_qte_header.quote_category_code := p_quote_category_code;
725: l_qte_header.quote_status_code := p_quote_status_code;
726: l_qte_header.quote_status := p_quote_status;
727: IF p_employee_person_id= ROSETTA_G_MISS_NUM THEN
728: l_qte_header.employee_person_id := FND_API.G_MISS_NUM;
729: ELSE
730: l_qte_header.employee_person_id := p_employee_person_id;
731: END IF;
732: l_qte_header.sales_channel_code := p_sales_channel_code;
753: l_qte_header.attribute7 := p_attribute7;
754: l_qte_header.attribute8 := p_attribute8;
755: l_qte_header.attribute9 := p_attribute9;
756: IF p_contract_id= ROSETTA_G_MISS_NUM THEN
757: l_qte_header.contract_id := FND_API.G_MISS_NUM;
758: ELSE
759: l_qte_header.contract_id := p_contract_id;
760: END IF;
761: IF p_qte_contract_id= ROSETTA_G_MISS_NUM THEN
758: ELSE
759: l_qte_header.contract_id := p_contract_id;
760: END IF;
761: IF p_qte_contract_id= ROSETTA_G_MISS_NUM THEN
762: l_qte_header.qte_contract_id := FND_API.G_MISS_NUM;
763: ELSE
764: l_qte_header.qte_contract_id := p_qte_contract_id;
765: END IF;
766: IF p_ffm_request_id= ROSETTA_G_MISS_NUM THEN
763: ELSE
764: l_qte_header.qte_contract_id := p_qte_contract_id;
765: END IF;
766: IF p_ffm_request_id= ROSETTA_G_MISS_NUM THEN
767: l_qte_header.ffm_request_id := FND_API.G_MISS_NUM;
768: ELSE
769: l_qte_header.ffm_request_id := p_ffm_request_id;
770: END IF;
771: l_qte_header.invoice_to_address1 := p_invoice_to_address1;
779: l_qte_header.invoice_to_country_code := p_invoice_to_country_code;
780: l_qte_header.invoice_to_country := p_invoice_to_country;
781: l_qte_header.invoice_to_county := p_invoice_to_county;
782: IF p_invoice_to_party_id= ROSETTA_G_MISS_NUM THEN
783: l_qte_header.invoice_to_party_id := FND_API.G_MISS_NUM;
784: ELSE
785: l_qte_header.invoice_to_party_id := p_invoice_to_party_id;
786: END IF;
787: l_qte_header.invoice_to_party_name := p_invoice_to_party_name;
785: l_qte_header.invoice_to_party_id := p_invoice_to_party_id;
786: END IF;
787: l_qte_header.invoice_to_party_name := p_invoice_to_party_name;
788: IF p_invoice_to_party_site_id= ROSETTA_G_MISS_NUM THEN
789: l_qte_header.invoice_to_party_site_id := FND_API.G_MISS_NUM;
790: ELSE
791: l_qte_header.invoice_to_party_site_id := p_invoice_to_party_site_id;
792: END IF;
793: l_qte_header.invoice_to_postal_code := p_invoice_to_postal_code;
793: l_qte_header.invoice_to_postal_code := p_invoice_to_postal_code;
794: l_qte_header.invoice_to_province := p_invoice_to_province;
795: l_qte_header.invoice_to_state := p_invoice_to_state;
796: IF p_invoicing_rule_id= ROSETTA_G_MISS_NUM THEN
797: l_qte_header.invoicing_rule_id := FND_API.G_MISS_NUM;
798: ELSE
799: l_qte_header.invoicing_rule_id := p_invoicing_rule_id;
800: END IF;
801: IF p_marketing_source_code_id= ROSETTA_G_MISS_NUM THEN
798: ELSE
799: l_qte_header.invoicing_rule_id := p_invoicing_rule_id;
800: END IF;
801: IF p_marketing_source_code_id= ROSETTA_G_MISS_NUM THEN
802: l_qte_header.marketing_source_code_id := FND_API.G_MISS_NUM;
803: ELSE
804: l_qte_header.marketing_source_code_id := p_marketing_source_code_id;
805: END IF;
806: l_qte_header.marketing_source_code := p_marketing_source_code;
805: END IF;
806: l_qte_header.marketing_source_code := p_marketing_source_code;
807: l_qte_header.marketing_source_name := p_marketing_source_name;
808: IF p_orig_mktg_source_code_id= ROSETTA_G_MISS_NUM THEN
809: l_qte_header.orig_mktg_source_code_id := FND_API.G_MISS_NUM;
810: ELSE
811: l_qte_header.orig_mktg_source_code_id := p_orig_mktg_source_code_id;
812: END IF;
813: IF p_order_type_id= ROSETTA_G_MISS_NUM THEN
810: ELSE
811: l_qte_header.orig_mktg_source_code_id := p_orig_mktg_source_code_id;
812: END IF;
813: IF p_order_type_id= ROSETTA_G_MISS_NUM THEN
814: l_qte_header.order_type_id := FND_API.G_MISS_NUM;
815: ELSE
816: l_qte_header.order_type_id := p_order_type_id;
817: END IF;
818: IF p_order_id= ROSETTA_G_MISS_NUM THEN
815: ELSE
816: l_qte_header.order_type_id := p_order_type_id;
817: END IF;
818: IF p_order_id= ROSETTA_G_MISS_NUM THEN
819: l_qte_header.order_id := FND_API.G_MISS_NUM;
820: ELSE
821: l_qte_header.order_id := p_order_id;
822: END IF;
823: IF p_order_number= ROSETTA_G_MISS_NUM THEN
820: ELSE
821: l_qte_header.order_id := p_order_id;
822: END IF;
823: IF p_order_number= ROSETTA_G_MISS_NUM THEN
824: l_qte_header.order_number := FND_API.G_MISS_NUM;
825: ELSE
826: l_qte_header.order_number := p_order_number;
827: END IF;
828: l_qte_header.order_type_name := p_order_type_name;
826: l_qte_header.order_number := p_order_number;
827: END IF;
828: l_qte_header.order_type_name := p_order_type_name;
829: IF p_ordered_date= ROSETTA_G_MISTAKE_DATE THEN
830: l_qte_header.ordered_date := FND_API.G_MISS_DATE;
831: ELSE
832: l_qte_header.ordered_date := p_ordered_date;
833: END IF;
834: IF p_resource_id = ROSETTA_G_MISS_NUM THEN
831: ELSE
832: l_qte_header.ordered_date := p_ordered_date;
833: END IF;
834: IF p_resource_id = ROSETTA_G_MISS_NUM THEN
835: l_qte_header.resource_id := FND_API.G_MISS_NUM;
836: ELSE
837: l_qte_header.resource_id := p_resource_id;
838: END IF;
839: RETURN l_qte_header;
856:
857: IF l_table_size > 0 THEN
858: FOR i IN 1..l_table_size LOOP
859: IF p_quote_header_id(i)= ROSETTA_G_MISS_NUM THEN
860: l_qte_line_tbl(i).quote_header_id := FND_API.G_MISS_NUM;
861: ELSE
862: l_qte_line_tbl(i).quote_header_id := p_quote_header_id(i);
863: END IF;
864: IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
861: ELSE
862: l_qte_line_tbl(i).quote_header_id := p_quote_header_id(i);
863: END IF;
864: IF p_quote_line_id(i)= ROSETTA_G_MISS_NUM THEN
865: l_qte_line_tbl(i).quote_line_id := FND_API.G_MISS_NUM;
866: ELSE
867: l_qte_line_tbl(i).quote_line_id := p_quote_line_id(i);
868: END IF;
869: l_qte_line_tbl(i).operation_code := 'UPDATE';
877:
878: PROCEDURE save_share_v2_wrapper
879: (
880: p_api_version_number IN NUMBER := 1 ,
881: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
882: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
878: PROCEDURE save_share_v2_wrapper
879: (
880: p_api_version_number IN NUMBER := 1 ,
881: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
882: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
880: p_api_version_number IN NUMBER := 1 ,
881: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
882: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
881: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
882: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
882: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
883:
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
884: p_c_last_update_date DATE := FND_API.G_MISS_DATE,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
885: p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
886: p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
887: p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
888: p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
889: p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
890: p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
891: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE', -- change line logic pricing
892: p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
893: p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
894: p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
895: p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
896:
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
897: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
898: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
899: p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
900: p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
901: p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
902: p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
903: p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
904: p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
905: p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
906: p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
907: p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
909: p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
910: p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
911: p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
912: p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
913: p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
914: p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
915: p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
916: p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
917: p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
918: p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
919: p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
920: p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
921: p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
922: p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
923: p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
924: p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
925: p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
926: p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
927: p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
928: p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
929: p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
930: p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
931: p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
932: p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
933: p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
934: p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
935: p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
936: p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
937: p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
938: p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
939: p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
940: p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
941: p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
942: p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
943: p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
944: p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
945: p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
946: p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
947: -- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
948: p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
949: -- bug 6873117 added attribute 16-20
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
950: p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
951: p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
952: p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
953: p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
954: p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
955: p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
956: p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
957: p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
958: p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
959: p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
960: p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
961: p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
962: p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
963: p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
965: p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
966: p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
967: p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
968: p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
969: p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
970: p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
971: p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
972: p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
974: p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
975: p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
976: p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
977: p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
978: p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
979: p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
980: p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
981: p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
982: p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
983: p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
984: p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
985: p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
986: p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
987: p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
988: p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
989: p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
990: p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
991: p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
992: p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
993: p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
994: p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
995: p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
996: p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004:
997: p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004:
1005: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
998: p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004:
1005: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1006: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
999: p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
1000: p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1001: --p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
1002: p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1003: p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
1004:
1005: p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
1006: p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
1007: p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
1025: p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
1026: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
1027: p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
1028: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1029: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1026: p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
1027: p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
1028: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1029: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1027: p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
1028: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1029: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1028: p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
1029: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1036: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1029: p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1036: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1037: x_return_status OUT NOCOPY VARCHAR2 ,
1030: p_party_id NUMBER := FND_API.G_MISS_NUM,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1036: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1037: x_return_status OUT NOCOPY VARCHAR2 ,
1038: x_msg_count OUT NOCOPY NUMBER ,
1031: P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1036: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1037: x_return_status OUT NOCOPY VARCHAR2 ,
1038: x_msg_count OUT NOCOPY NUMBER ,
1039: x_msg_data OUT NOCOPY VARCHAR2 ) is
1032: P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
1033: p_minisite_id NUMBER := FND_API.G_MISS_NUM,
1034: P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
1035: P_source_last_update_date DATE := FND_API.G_MISS_DATE,
1036: p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
1037: x_return_status OUT NOCOPY VARCHAR2 ,
1038: x_msg_count OUT NOCOPY NUMBER ,
1039: x_msg_data OUT NOCOPY VARCHAR2 ) is
1040: