eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_REJECTED_LINES_ACK dependencies on FND_API

Line 46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)

42: Lines cursor
43: -----------------------------------------------------------
44: */
45: CURSOR l_line_cursor IS
46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)

Line 47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)

43: -----------------------------------------------------------
44: */
45: CURSOR l_line_cursor IS
46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)

Line 48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)

44: */
45: CURSOR l_line_cursor IS
46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)

Line 49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)

45: CURSOR l_line_cursor IS
46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)

Line 50: , nvl(change_request_code, FND_API.G_MISS_CHAR)

46: SELECT nvl(order_source_id, FND_API.G_MISS_NUM)
47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)

Line 51: , nvl(org_id, FND_API.G_MISS_NUM)

47: , nvl(orig_sys_document_ref, FND_API.G_MISS_CHAR)
48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)

Line 52: , nvl(line_number, FND_API.G_MISS_NUM)

48: , nvl(orig_sys_line_ref, FND_API.G_MISS_CHAR)
49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type

Line 53: , nvl(shipment_number, FND_API.G_MISS_NUM)

49: , nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)

Line 54: , nvl(line_id, FND_API.G_MISS_NUM)

50: , nvl(change_request_code, FND_API.G_MISS_CHAR)
51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)

Line 55: , nvl(line_type_id, FND_API.G_MISS_NUM)

51: , nvl(org_id, FND_API.G_MISS_NUM)
52: , nvl(line_number, FND_API.G_MISS_NUM)
53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item

Line 57: , nvl(item_type_code, FND_API.G_MISS_CHAR)

53: , nvl(shipment_number, FND_API.G_MISS_NUM)
54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)

Line 58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)

54: , nvl(line_id, FND_API.G_MISS_NUM)
55: , nvl(line_type_id, FND_API.G_MISS_NUM)
56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)

Line 60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)

56: , line_type
57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)

Line 61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)

57: , nvl(item_type_code, FND_API.G_MISS_CHAR)
58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)

Line 62: , nvl(explosion_date, FND_API.G_MISS_DATE)

58: , nvl(inventory_item_id, FND_API.G_MISS_NUM)
59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)

Line 63: , nvl(ato_line_id, FND_API.G_MISS_NUM)

59: , inventory_item
60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)

Line 64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)

60: , nvl(top_model_line_ref, FND_API.G_MISS_CHAR)
61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)

Line 65: , nvl(component_code, FND_API.G_MISS_CHAR)

61: , nvl(link_to_line_ref, FND_API.G_MISS_CHAR)
62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')

Line 66: , nvl(sort_order, FND_API.G_MISS_CHAR)

62: , nvl(explosion_date, FND_API.G_MISS_DATE)
63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)

Line 67: , nvl(model_group_number, FND_API.G_MISS_NUM)

63: , nvl(ato_line_id, FND_API.G_MISS_NUM)
64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)

Line 68: , nvl(option_number, FND_API.G_MISS_NUM)

64: , nvl(component_sequence_id, FND_API.G_MISS_NUM)
65: , nvl(component_code, FND_API.G_MISS_CHAR)
66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)

Line 70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)

66: , nvl(sort_order, FND_API.G_MISS_CHAR)
67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)

Line 71: , nvl(source_type_code, FND_API.G_MISS_CHAR)

67: , nvl(model_group_number, FND_API.G_MISS_NUM)
68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)

Line 72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)

68: , nvl(option_number, FND_API.G_MISS_NUM)
69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)

Line 73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)

69: , nvl(option_flag, 'N')
70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)

Line 74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)

70: , nvl(ship_model_complete_flag, FND_API.G_MISS_CHAR)
71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)

Line 75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)

71: , nvl(source_type_code, FND_API.G_MISS_CHAR)
72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)

Line 76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)

72: , nvl(schedule_status_code, FND_API.G_MISS_CHAR)
73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)

Line 77: , nvl(request_date, FND_API.G_MISS_DATE)

73: , nvl(schedule_ship_date, FND_API.G_MISS_DATE)
74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)

Line 78: , nvl(promise_date, FND_API.G_MISS_DATE)

74: , nvl(late_demand_penalty_factor, FND_API.G_MISS_NUM)
75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)

Line 79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)

75: , nvl(schedule_arrival_date, FND_API.G_MISS_DATE)
76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)

Line 80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)

76: , nvl(actual_arrival_date, FND_API.G_MISS_DATE)
77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)

Line 81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)

77: , nvl(request_date, FND_API.G_MISS_DATE)
78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)

Line 82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)

78: , nvl(promise_date, FND_API.G_MISS_DATE)
79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)

Line 83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)

79: , nvl(delivery_lead_time, FND_API.G_MISS_NUM)
80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */

Line 84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)

80: , nvl(ordered_quantity, FND_API.G_MISS_NUM)
81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)

Line 85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)

81: , nvl(order_quantity_uom , FND_API.G_MISS_CHAR)
82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)

Line 86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)

82: , nvl(shipping_quantity, FND_API.G_MISS_NUM)
83: , nvl(shipping_quantity_uom, FND_API.G_MISS_CHAR)
84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)

Line 88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)

84: , nvl(shipped_quantity, FND_API.G_MISS_NUM)
85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)

Line 89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)

85: , nvl(cancelled_quantity, FND_API.G_MISS_NUM)
86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)

Line 90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)

86: , nvl(fulfilled_quantity, FND_API.G_MISS_NUM)
87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)

Line 91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)

87: /* OPM variables */
88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)

Line 92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)

88: , nvl(ordered_quantity2, FND_API.G_MISS_NUM)
89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */

Line 93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)

89: , nvl(ordered_quantity_uom2 , FND_API.G_MISS_CHAR)
90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)

Line 94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)

90: , nvl(shipping_quantity2, FND_API.G_MISS_NUM)
91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)

Line 95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)

91: , nvl(shipping_quantity_uom2, FND_API.G_MISS_CHAR)
92: , nvl(shipped_quantity2, FND_API.G_MISS_NUM)
93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)

Line 97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)

93: , nvl(cancelled_quantity2, FND_API.G_MISS_NUM)
94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)
100: , sold_from_org
101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)

Line 98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)

94: , nvl(fulfilled_quantity2, FND_API.G_MISS_NUM)
95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)
100: , sold_from_org
101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)
102: , sold_to_org

Line 99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)

95: , nvl(preferred_grade, FND_API.G_MISS_CHAR)
96: /* end of OPM variables */
97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)
100: , sold_from_org
101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)
102: , sold_to_org
103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)

Line 101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)

97: , nvl(pricing_quantity, FND_API.G_MISS_NUM)
98: , nvl(pricing_quantity_uom, FND_API.G_MISS_CHAR)
99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)
100: , sold_from_org
101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)
102: , sold_to_org
103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)
104: , ship_from_org
105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)

Line 103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)

99: , nvl(sold_from_org_id, FND_API.G_MISS_NUM)
100: , sold_from_org
101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)
102: , sold_to_org
103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)
104: , ship_from_org
105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)
106: , ship_to_org
107: , nvl(deliver_to_org_id, FND_API.G_MISS_NUM)

Line 105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)

101: , nvl(sold_to_org_id , FND_API.G_MISS_NUM)
102: , sold_to_org
103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)
104: , ship_from_org
105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)
106: , ship_to_org
107: , nvl(deliver_to_org_id, FND_API.G_MISS_NUM)
108: , deliver_to_org
109: , nvl(invoice_to_org_id, FND_API.G_MISS_NUM)

Line 107: , nvl(deliver_to_org_id, FND_API.G_MISS_NUM)

103: , nvl(ship_from_org_id, FND_API.G_MISS_NUM)
104: , ship_from_org
105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)
106: , ship_to_org
107: , nvl(deliver_to_org_id, FND_API.G_MISS_NUM)
108: , deliver_to_org
109: , nvl(invoice_to_org_id, FND_API.G_MISS_NUM)
110: , invoice_to_org
111: , ship_to_address1

Line 109: , nvl(invoice_to_org_id, FND_API.G_MISS_NUM)

105: , nvl(ship_to_org_id , FND_API.G_MISS_NUM)
106: , ship_to_org
107: , nvl(deliver_to_org_id, FND_API.G_MISS_NUM)
108: , deliver_to_org
109: , nvl(invoice_to_org_id, FND_API.G_MISS_NUM)
110: , invoice_to_org
111: , ship_to_address1
112: , ship_to_address2
113: , ship_to_address3

Line 119: , nvl(ship_to_contact_id, FND_API.G_MISS_NUM)

115: , ship_to_city
116: , ship_to_state
117: , ship_to_postal_code
118: , ship_to_country
119: , nvl(ship_to_contact_id, FND_API.G_MISS_NUM)
120: , ship_to_contact
121: , nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)
122: , deliver_to_contact
123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)

Line 121: , nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)

117: , ship_to_postal_code
118: , ship_to_country
119: , nvl(ship_to_contact_id, FND_API.G_MISS_NUM)
120: , ship_to_contact
121: , nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)
122: , deliver_to_contact
123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)

Line 123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)

119: , nvl(ship_to_contact_id, FND_API.G_MISS_NUM)
120: , ship_to_contact
121: , nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)
122: , deliver_to_contact
123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)

Line 125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)

121: , nvl(deliver_to_contact_id, FND_API.G_MISS_NUM)
122: , deliver_to_contact
123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list

Line 126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)

122: , deliver_to_contact
123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)

Line 127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)

123: , nvl(invoice_to_contact_id, FND_API.G_MISS_NUM)
124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)

Line 128: , nvl(price_list_id, FND_API.G_MISS_NUM)

124: , invoice_to_contact
125: , nvl(drop_ship_flag, FND_API.G_MISS_CHAR)
126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)

Line 130: , nvl(pricing_date, FND_API.G_MISS_DATE)

126: , nvl(ship_tolerance_above, FND_API.G_MISS_NUM)
127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)

Line 131: , nvl(unit_list_price, FND_API.G_MISS_NUM)

127: , nvl(ship_tolerance_below, FND_API.G_MISS_NUM)
128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)

Line 132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)

128: , nvl(price_list_id, FND_API.G_MISS_NUM)
129: , price_list
130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)

Line 134: , nvl(ship_set_id, FND_API.G_MISS_NUM)

130: , nvl(pricing_date, FND_API.G_MISS_DATE)
131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)

Line 135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)

131: , nvl(unit_list_price, FND_API.G_MISS_NUM)
132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)

Line 136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)

132: , nvl(unit_selling_price, FND_API.G_MISS_NUM)
133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)

Line 137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)

133: , nvl(calculate_price_flag, 'Y')
134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)

Line 138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)

134: , nvl(ship_set_id, FND_API.G_MISS_NUM)
135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)

Line 139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)

135: , nvl(ship_set_name, FND_API.G_MISS_CHAR)
136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)

Line 140: , nvl(tax_code, FND_API.G_MISS_CHAR)

136: , nvl(arrival_set_id, FND_API.G_MISS_NUM)
137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point

Line 141: , nvl(tax_value, FND_API.G_MISS_NUM)

137: , nvl(arrival_set_name, FND_API.G_MISS_CHAR)
138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)

Line 142: , nvl(tax_date, FND_API.G_MISS_DATE)

138: , nvl(fulfillment_set_id, FND_API.G_MISS_NUM)
139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)

Line 143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)

139: , nvl(fulfillment_set_name, FND_API.G_MISS_CHAR)
140: , nvl(tax_code, FND_API.G_MISS_CHAR)
141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)

Line 145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)

141: , nvl(tax_value, FND_API.G_MISS_NUM)
142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
148: , tax_exempt_reason
149: , nvl(agreement_id, FND_API.G_MISS_NUM)

Line 146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)

142: , nvl(tax_date, FND_API.G_MISS_DATE)
143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
148: , tax_exempt_reason
149: , nvl(agreement_id, FND_API.G_MISS_NUM)
150: , agreement

Line 147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)

143: , nvl(tax_point_code, FND_API.G_MISS_CHAR)
144: , tax_point
145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
148: , tax_exempt_reason
149: , nvl(agreement_id, FND_API.G_MISS_NUM)
150: , agreement
151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)

Line 149: , nvl(agreement_id, FND_API.G_MISS_NUM)

145: , nvl(tax_exempt_flag, FND_API.G_MISS_CHAR)
146: , nvl(tax_exempt_number, FND_API.G_MISS_CHAR)
147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
148: , tax_exempt_reason
149: , nvl(agreement_id, FND_API.G_MISS_NUM)
150: , agreement
151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)
152: , invoicing_rule
153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)

Line 151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)

147: , nvl(tax_exempt_reason_code, FND_API.G_MISS_CHAR)
148: , tax_exempt_reason
149: , nvl(agreement_id, FND_API.G_MISS_NUM)
150: , agreement
151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)
152: , invoicing_rule
153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)
154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
155: , accounting_rule

Line 153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)

149: , nvl(agreement_id, FND_API.G_MISS_NUM)
150: , agreement
151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)
152: , invoicing_rule
153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)
154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
155: , accounting_rule
156: , nvl(payment_term_id, FND_API.G_MISS_NUM)
157: , payment_term

Line 154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)

150: , agreement
151: , nvl(invoicing_rule_id, FND_API.G_MISS_NUM)
152: , invoicing_rule
153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)
154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
155: , accounting_rule
156: , nvl(payment_term_id, FND_API.G_MISS_NUM)
157: , payment_term
158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)

Line 156: , nvl(payment_term_id, FND_API.G_MISS_NUM)

152: , invoicing_rule
153: , nvl(accounting_rule_id, FND_API.G_MISS_NUM)
154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
155: , accounting_rule
156: , nvl(payment_term_id, FND_API.G_MISS_NUM)
157: , payment_term
158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)
159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority

Line 158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)

154: , nvl(accounting_rule_duration, FND_API.G_MISS_NUM)
155: , accounting_rule
156: , nvl(payment_term_id, FND_API.G_MISS_NUM)
157: , payment_term
158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)
159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)

Line 159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)

155: , accounting_rule
156: , nvl(payment_term_id, FND_API.G_MISS_NUM)
157: , payment_term
158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)
159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)

Line 161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)

157: , payment_term
158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)
159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)

Line 162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)

158: , nvl(demand_class_code, FND_API.G_MISS_CHAR)
159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms

Line 163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)

159: , nvl(shipment_priority_code, FND_API.G_MISS_CHAR)
160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)

Line 164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)

160: , shipment_priority
161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point

Line 165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)

161: , nvl(shipping_method_code, FND_API.G_MISS_CHAR)
162: , nvl(shipping_instructions, FND_API.G_MISS_CHAR)
163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)

Line 167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)

163: , nvl(packing_instructions, FND_API.G_MISS_CHAR)
164: , nvl(freight_carrier_code, FND_API.G_MISS_CHAR)
165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)

Line 169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)

165: , nvl(freight_terms_code, FND_API.G_MISS_CHAR)
166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)

Line 170: , nvl(reference_type, FND_API.G_MISS_CHAR)

166: , freight_terms
167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)

Line 171: , nvl(reference_header_id, FND_API.G_MISS_NUM)

167: , nvl(fob_point_code, FND_API.G_MISS_CHAR)
168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)

Line 172: , nvl(reference_line_id, FND_API.G_MISS_NUM)

168: , fob_point
169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)

Line 173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)

169: , nvl(return_reason_code, FND_API.G_MISS_CHAR)
170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)

Line 174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)

170: , nvl(reference_type, FND_API.G_MISS_CHAR)
171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)

Line 175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)

171: , nvl(reference_header_id, FND_API.G_MISS_NUM)
172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)

Line 176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)

172: , nvl(reference_line_id, FND_API.G_MISS_NUM)
173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)

Line 177: , nvl(customer_item_id, FND_API.G_MISS_NUM)

173: , nvl(credit_invoice_line_id, FND_API.G_MISS_NUM)
174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)

Line 178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)

174: , nvl(customer_po_number, FND_API.G_MISS_CHAR)
175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)

Line 179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)

175: , nvl(customer_line_number, FND_API.G_MISS_CHAR)
176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term

Line 180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)

176: , nvl(customer_shipment_number, FND_API.G_MISS_CHAR)
177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)

Line 181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)

177: , nvl(customer_item_id, FND_API.G_MISS_NUM)
178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type

Line 182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)

178: , nvl(customer_item_id_type, FND_API.G_MISS_CHAR)
179: , nvl(customer_item_name, FND_API.G_MISS_CHAR)
180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)

Line 184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)

180: -- , nvl(customer_item_revision, FND_API.G_MISS_CHAR)
181: , nvl(customer_item_net_price, FND_API.G_MISS_NUM)
182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)

Line 186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)

182: , nvl(customer_payment_term_id, FND_API.G_MISS_NUM)
183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)

Line 187: , nvl(customer_job, FND_API.G_MISS_CHAR)

183: , customer_payment_term
184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project

Line 188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)

184: , nvl(demand_bucket_type_code, FND_API.G_MISS_CHAR)
185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)

Line 189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)

185: , demand_bucket_type
186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task

Line 190: , nvl(project_id, FND_API.G_MISS_NUM)

186: , nvl(customer_dock_code, FND_API.G_MISS_CHAR)
187: , nvl(customer_job, FND_API.G_MISS_CHAR)
188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)

Line 192: , nvl(task_id, FND_API.G_MISS_NUM)

188: , nvl(customer_production_line, FND_API.G_MISS_CHAR)
189: , nvl(cust_model_serial_number, FND_API.G_MISS_CHAR)
190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)

Line 194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)

190: , nvl(project_id, FND_API.G_MISS_NUM)
191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)

Line 195: , nvl(item_revision, FND_API.G_MISS_CHAR)

191: , project
192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)

Line 196: , nvl(service_duration, FND_API.G_MISS_NUM)

192: , nvl(task_id, FND_API.G_MISS_NUM)
193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)

Line 197: , nvl(service_period, FND_API.G_MISS_CHAR)

193: , task
194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)

Line 198: , nvl(service_start_date, FND_API.G_MISS_DATE)

194: , nvl(end_item_unit_number, FND_API.G_MISS_CHAR)
195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)

Line 199: , nvl(service_end_date, FND_API.G_MISS_DATE)

195: , nvl(item_revision, FND_API.G_MISS_CHAR)
196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)

Line 200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)

196: , nvl(service_duration, FND_API.G_MISS_NUM)
197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)

Line 201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)

197: , nvl(service_period, FND_API.G_MISS_CHAR)
198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded

Line 202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)

198: , nvl(service_start_date, FND_API.G_MISS_DATE)
199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)

Line 203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)

199: , nvl(service_end_date, FND_API.G_MISS_DATE)
200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)

Line 204: , nvl(service_number, FND_API.G_MISS_NUM)

200: , nvl(service_coterminate_flag, FND_API.G_MISS_CHAR)
201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)

Line 205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded

201: , nvl(unit_selling_percent, FND_API.G_MISS_NUM)
202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)

Line 206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)

202: , nvl(unit_list_percent, FND_API.G_MISS_NUM)
203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)

Line 207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)

203: , nvl(unit_percent_base_price, FND_API.G_MISS_NUM)
204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)

Line 208: , nvl(context, FND_API.G_MISS_CHAR)

204: , nvl(service_number, FND_API.G_MISS_NUM)
205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)

Line 209: , nvl(attribute1, FND_API.G_MISS_CHAR)

205: -- , nvl(fulfilled_flag, FND_API.G_MISS_CHAR)--ToBeAdded
206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)

Line 210: , nvl(attribute2, FND_API.G_MISS_CHAR)

206: -- , nvl(closed_flag, FND_API.G_MISS_CHAR)
207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)

Line 211: , nvl(attribute3, FND_API.G_MISS_CHAR)

207: , nvl(cancelled_flag, FND_API.G_MISS_CHAR)
208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)

Line 212: , nvl(attribute4, FND_API.G_MISS_CHAR)

208: , nvl(context, FND_API.G_MISS_CHAR)
209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)

Line 213: , nvl(attribute5, FND_API.G_MISS_CHAR)

209: , nvl(attribute1, FND_API.G_MISS_CHAR)
210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)

Line 214: , nvl(attribute6, FND_API.G_MISS_CHAR)

210: , nvl(attribute2, FND_API.G_MISS_CHAR)
211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)

Line 215: , nvl(attribute7, FND_API.G_MISS_CHAR)

211: , nvl(attribute3, FND_API.G_MISS_CHAR)
212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)

Line 216: , nvl(attribute8, FND_API.G_MISS_CHAR)

212: , nvl(attribute4, FND_API.G_MISS_CHAR)
213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)

Line 217: , nvl(attribute9, FND_API.G_MISS_CHAR)

213: , nvl(attribute5, FND_API.G_MISS_CHAR)
214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)

Line 218: , nvl(attribute10, FND_API.G_MISS_CHAR)

214: , nvl(attribute6, FND_API.G_MISS_CHAR)
215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)

Line 219: , nvl(attribute11, FND_API.G_MISS_CHAR)

215: , nvl(attribute7, FND_API.G_MISS_CHAR)
216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)

Line 220: , nvl(attribute12, FND_API.G_MISS_CHAR)

216: , nvl(attribute8, FND_API.G_MISS_CHAR)
217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255

Line 221: , nvl(attribute13, FND_API.G_MISS_CHAR)

217: , nvl(attribute9, FND_API.G_MISS_CHAR)
218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)

Line 222: , nvl(attribute14, FND_API.G_MISS_CHAR)

218: , nvl(attribute10, FND_API.G_MISS_CHAR)
219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)

Line 223: , nvl(attribute15, FND_API.G_MISS_CHAR)

219: , nvl(attribute11, FND_API.G_MISS_CHAR)
220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)

Line 224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255

220: , nvl(attribute12, FND_API.G_MISS_CHAR)
221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)

Line 225: , nvl(attribute17, FND_API.G_MISS_CHAR)

221: , nvl(attribute13, FND_API.G_MISS_CHAR)
222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)

Line 226: , nvl(attribute18, FND_API.G_MISS_CHAR)

222: , nvl(attribute14, FND_API.G_MISS_CHAR)
223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)

Line 227: , nvl(attribute19, FND_API.G_MISS_CHAR)

223: , nvl(attribute15, FND_API.G_MISS_CHAR)
224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)

Line 228: , nvl(attribute20, FND_API.G_MISS_CHAR)

224: , nvl(attribute16, FND_API.G_MISS_CHAR) -- for bug 2184255
225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)

Line 229: , nvl(tp_context, FND_API.G_MISS_CHAR)

225: , nvl(attribute17, FND_API.G_MISS_CHAR)
226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)

Line 230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)

226: , nvl(attribute18, FND_API.G_MISS_CHAR)
227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)

Line 231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)

227: , nvl(attribute19, FND_API.G_MISS_CHAR)
228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)

Line 232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)

228: , nvl(attribute20, FND_API.G_MISS_CHAR)
229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)

Line 233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)

229: , nvl(tp_context, FND_API.G_MISS_CHAR)
230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)

Line 234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)

230: , nvl(tp_attribute1, FND_API.G_MISS_CHAR)
231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)

Line 235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)

231: , nvl(tp_attribute2, FND_API.G_MISS_CHAR)
232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)

Line 236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)

232: , nvl(tp_attribute3, FND_API.G_MISS_CHAR)
233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)

Line 237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)

233: , nvl(tp_attribute4, FND_API.G_MISS_CHAR)
234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)

Line 238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)

234: , nvl(tp_attribute5, FND_API.G_MISS_CHAR)
235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)

Line 239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)

235: , nvl(tp_attribute6, FND_API.G_MISS_CHAR)
236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)

Line 240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)

236: , nvl(tp_attribute7, FND_API.G_MISS_CHAR)
237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)

Line 241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)

237: , nvl(tp_attribute8, FND_API.G_MISS_CHAR)
238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)

Line 242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)

238: , nvl(tp_attribute9, FND_API.G_MISS_CHAR)
239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)

Line 243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)

239: , nvl(tp_attribute10, FND_API.G_MISS_CHAR)
240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)

Line 244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)

240: , nvl(tp_attribute11, FND_API.G_MISS_CHAR)
241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)

Line 245: , nvl(industry_context, FND_API.G_MISS_CHAR)

241: , nvl(tp_attribute12, FND_API.G_MISS_CHAR)
242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)

Line 246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)

242: , nvl(tp_attribute13, FND_API.G_MISS_CHAR)
243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)

Line 247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)

243: , nvl(tp_attribute14, FND_API.G_MISS_CHAR)
244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)

Line 248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)

244: , nvl(tp_attribute15, FND_API.G_MISS_CHAR)
245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)

Line 249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)

245: , nvl(industry_context, FND_API.G_MISS_CHAR)
246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)

Line 250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)

246: , nvl(industry_attribute1, FND_API.G_MISS_CHAR)
247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)

Line 251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)

247: , nvl(industry_attribute2, FND_API.G_MISS_CHAR)
248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)

Line 252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)

248: , nvl(industry_attribute3, FND_API.G_MISS_CHAR)
249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)

Line 253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)

249: , nvl(industry_attribute4, FND_API.G_MISS_CHAR)
250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)

Line 254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)

250: , nvl(industry_attribute5, FND_API.G_MISS_CHAR)
251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)

Line 255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)

251: , nvl(industry_attribute6, FND_API.G_MISS_CHAR)
252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)

Line 256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)

252: , nvl(industry_attribute7, FND_API.G_MISS_CHAR)
253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)

Line 257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)

253: , nvl(industry_attribute8, FND_API.G_MISS_CHAR)
254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)

Line 258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)

254: , nvl(industry_attribute9, FND_API.G_MISS_CHAR)
255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)

Line 259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)

255: , nvl(industry_attribute10, FND_API.G_MISS_CHAR)
256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)

Line 260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)

256: , nvl(industry_attribute11, FND_API.G_MISS_CHAR)
257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)

Line 261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)

257: , nvl(industry_attribute12, FND_API.G_MISS_CHAR)
258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)

Line 262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)

258: , nvl(industry_attribute13, FND_API.G_MISS_CHAR)
259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)

Line 263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)

259: , nvl(industry_attribute14, FND_API.G_MISS_CHAR)
260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)

Line 264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)

260: , nvl(industry_attribute15, FND_API.G_MISS_CHAR)
261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)

Line 265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)

261: , nvl(industry_attribute16, FND_API.G_MISS_CHAR)
262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)

Line 266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)

262: , nvl(industry_attribute17, FND_API.G_MISS_CHAR)
263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)

Line 267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)

263: , nvl(industry_attribute18, FND_API.G_MISS_CHAR)
264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)

Line 268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)

264: , nvl(industry_attribute19, FND_API.G_MISS_CHAR)
265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)

Line 269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)

265: , nvl(industry_attribute20, FND_API.G_MISS_CHAR)
266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)

Line 270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)

266: , nvl(industry_attribute21, FND_API.G_MISS_CHAR)
267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)

Line 271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)

267: , nvl(industry_attribute22, FND_API.G_MISS_CHAR)
268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)

Line 272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)

268: , nvl(industry_attribute23, FND_API.G_MISS_CHAR)
269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)

Line 273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)

269: , nvl(industry_attribute24, FND_API.G_MISS_CHAR)
270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)

Line 274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)

270: , nvl(industry_attribute25, FND_API.G_MISS_CHAR)
271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)

Line 275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)

271: , nvl(industry_attribute26, FND_API.G_MISS_CHAR)
272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)

Line 276: , nvl(pricing_context, FND_API.G_MISS_CHAR)

272: , nvl(industry_attribute27, FND_API.G_MISS_CHAR)
273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)

Line 277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)

273: , nvl(industry_attribute28, FND_API.G_MISS_CHAR)
274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)

Line 278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)

274: , nvl(industry_attribute29, FND_API.G_MISS_CHAR)
275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)

Line 279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)

275: , nvl(industry_attribute30, FND_API.G_MISS_CHAR)
276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)

Line 280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)

276: , nvl(pricing_context, FND_API.G_MISS_CHAR)
277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)

Line 281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)

277: , nvl(pricing_attribute1, FND_API.G_MISS_CHAR)
278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)

Line 282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)

278: , nvl(pricing_attribute2, FND_API.G_MISS_CHAR)
279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)

Line 283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)

279: , nvl(pricing_attribute3, FND_API.G_MISS_CHAR)
280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)

Line 284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)

280: , nvl(pricing_attribute4, FND_API.G_MISS_CHAR)
281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)

Line 285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)

281: , nvl(pricing_attribute5, FND_API.G_MISS_CHAR)
282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)

Line 286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)

282: , nvl(pricing_attribute6, FND_API.G_MISS_CHAR)
283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)

Line 287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)

283: , nvl(pricing_attribute7, FND_API.G_MISS_CHAR)
284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)

Line 288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)

284: , nvl(pricing_attribute8, FND_API.G_MISS_CHAR)
285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)

Line 289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)

285: , nvl(pricing_attribute9, FND_API.G_MISS_CHAR)
286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)

Line 290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)

286: , nvl(pricing_attribute10, FND_API.G_MISS_CHAR)
287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)

Line 291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)

287: , nvl(global_attribute_category, FND_API.G_MISS_CHAR)
288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)

Line 292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)

288: , nvl(global_attribute1, FND_API.G_MISS_CHAR)
289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)

Line 293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)

289: , nvl(global_attribute2, FND_API.G_MISS_CHAR)
290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)

Line 294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)

290: , nvl(global_attribute3, FND_API.G_MISS_CHAR)
291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)

Line 295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)

291: , nvl(global_attribute4, FND_API.G_MISS_CHAR)
292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)

Line 296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)

292: , nvl(global_attribute5, FND_API.G_MISS_CHAR)
293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)

Line 297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)

293: , nvl(global_attribute6, FND_API.G_MISS_CHAR)
294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)

Line 298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)

294: , nvl(global_attribute7, FND_API.G_MISS_CHAR)
295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)

Line 299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)

295: , nvl(global_attribute8, FND_API.G_MISS_CHAR)
296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)

Line 300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)

296: , nvl(global_attribute9, FND_API.G_MISS_CHAR)
297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)

Line 301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)

297: , nvl(global_attribute10, FND_API.G_MISS_CHAR)
298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)

Line 302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)

298: , nvl(global_attribute11, FND_API.G_MISS_CHAR)
299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)

Line 303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)

299: , nvl(global_attribute12, FND_API.G_MISS_CHAR)
300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)

Line 304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)

300: , nvl(global_attribute13, FND_API.G_MISS_CHAR)
301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)

Line 305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)

301: , nvl(global_attribute14, FND_API.G_MISS_CHAR)
302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)

Line 306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)

302: , nvl(global_attribute15, FND_API.G_MISS_CHAR)
303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)

Line 307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)

303: , nvl(global_attribute16, FND_API.G_MISS_CHAR)
304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)

Line 308: , nvl(return_context, FND_API.G_MISS_CHAR)

304: , nvl(global_attribute17, FND_API.G_MISS_CHAR)
305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)

Line 309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)

305: , nvl(global_attribute18, FND_API.G_MISS_CHAR)
306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)

Line 310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)

306: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)

Line 311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)

307: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)

Line 312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)

308: , nvl(return_context, FND_API.G_MISS_CHAR)
309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)

Line 313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)

309: , nvl(return_attribute1, FND_API.G_MISS_CHAR)
310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)

Line 314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)

310: , nvl(return_attribute2, FND_API.G_MISS_CHAR)
311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)

Line 315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)

311: , nvl(return_attribute3, FND_API.G_MISS_CHAR)
312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)

Line 316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)

312: , nvl(return_attribute4, FND_API.G_MISS_CHAR)
313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)

Line 317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)

313: , nvl(return_attribute5, FND_API.G_MISS_CHAR)
314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)

Line 318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)

314: , nvl(return_attribute6, FND_API.G_MISS_CHAR)
315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)

Line 319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)

315: , nvl(return_attribute7, FND_API.G_MISS_CHAR)
316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)

Line 320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)

316: , nvl(return_attribute8, FND_API.G_MISS_CHAR)
317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id

Line 321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)

317: , nvl(return_attribute9, FND_API.G_MISS_CHAR)
318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

Line 322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)

318: , nvl(return_attribute10, FND_API.G_MISS_CHAR)
319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)

Line 323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)

319: , nvl(return_attribute11, FND_API.G_MISS_CHAR)
320: , nvl(return_attribute12, FND_API.G_MISS_CHAR)
321: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)

Line 326: , nvl(status_flag, FND_API.G_MISS_CHAR)

322: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)

Line 327: , nvl(change_reason, FND_API.G_MISS_CHAR)

323: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)

Line 328: , nvl(change_comments, FND_API.G_MISS_CHAR)

324: , request_id
325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)

Line 329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)

325: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)

Line 330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)

326: , nvl(status_flag, FND_API.G_MISS_CHAR)
327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)
334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)

Line 331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)

327: , nvl(change_reason, FND_API.G_MISS_CHAR)
328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)
334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)
335: , INVENTORY_ITEM_SEGMENT_1

Line 332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)

328: , nvl(change_comments, FND_API.G_MISS_CHAR)
329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)
334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)
335: , INVENTORY_ITEM_SEGMENT_1
336: , INVENTORY_ITEM_SEGMENT_2

Line 333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)

329: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)
330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)
334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)
335: , INVENTORY_ITEM_SEGMENT_1
336: , INVENTORY_ITEM_SEGMENT_2
337: , INVENTORY_ITEM_SEGMENT_3

Line 334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)

330: , nvl(service_txn_comments, FND_API.G_MISS_CHAR)
331: , nvl(service_reference_type_code, FND_API.G_MISS_CHAR)
332: , nvl(service_reference_order, FND_API.G_MISS_CHAR)
333: , nvl(service_reference_line, FND_API.G_MISS_CHAR)
334: , nvl(service_reference_system, FND_API.G_MISS_CHAR)
335: , INVENTORY_ITEM_SEGMENT_1
336: , INVENTORY_ITEM_SEGMENT_2
337: , INVENTORY_ITEM_SEGMENT_3
338: , INVENTORY_ITEM_SEGMENT_4

Line 356: , nvl(commitment_id, FND_API.G_MISS_NUM)

352: , INVENTORY_ITEM_SEGMENT_18
353: , INVENTORY_ITEM_SEGMENT_19
354: , INVENTORY_ITEM_SEGMENT_20
355: , commitment
356: , nvl(commitment_id, FND_API.G_MISS_NUM)
357: -- aksingh subinventory
358: , nvl(subinventory, FND_API.G_MISS_CHAR)
359: , salesrep
360: , nvl(salesrep_id, FND_API.G_MISS_NUM)

Line 358: , nvl(subinventory, FND_API.G_MISS_CHAR)

354: , INVENTORY_ITEM_SEGMENT_20
355: , commitment
356: , nvl(commitment_id, FND_API.G_MISS_NUM)
357: -- aksingh subinventory
358: , nvl(subinventory, FND_API.G_MISS_CHAR)
359: , salesrep
360: , nvl(salesrep_id, FND_API.G_MISS_NUM)
361: , nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)
362: , nvl(latest_acceptable_date, FND_API.G_MISS_DATE)

Line 360: , nvl(salesrep_id, FND_API.G_MISS_NUM)

356: , nvl(commitment_id, FND_API.G_MISS_NUM)
357: -- aksingh subinventory
358: , nvl(subinventory, FND_API.G_MISS_CHAR)
359: , salesrep
360: , nvl(salesrep_id, FND_API.G_MISS_NUM)
361: , nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)
362: , nvl(latest_acceptable_date, FND_API.G_MISS_DATE)
363: , split_from_line_ref --bsadri
364: , split_from_shipment_ref

Line 361: , nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)

357: -- aksingh subinventory
358: , nvl(subinventory, FND_API.G_MISS_CHAR)
359: , salesrep
360: , nvl(salesrep_id, FND_API.G_MISS_NUM)
361: , nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)
362: , nvl(latest_acceptable_date, FND_API.G_MISS_DATE)
363: , split_from_line_ref --bsadri
364: , split_from_shipment_ref
365: , invoice_to_address1

Line 362: , nvl(latest_acceptable_date, FND_API.G_MISS_DATE)

358: , nvl(subinventory, FND_API.G_MISS_CHAR)
359: , salesrep
360: , nvl(salesrep_id, FND_API.G_MISS_NUM)
361: , nvl(earliest_acceptable_date, FND_API.G_MISS_DATE)
362: , nvl(latest_acceptable_date, FND_API.G_MISS_DATE)
363: , split_from_line_ref --bsadri
364: , split_from_shipment_ref
365: , invoice_to_address1
366: , invoice_to_address2

Line 381: , nvl(Config_Header_Id, FND_API.G_MISS_NUM)

377: -- , Ship_to_Contact_Ref
378: -- , Bill_to_Contact_Ref
379: -- , Deliver_to_Contact_Ref
380: -- End add new columns to select for the Add Customer}
381: , nvl(Config_Header_Id, FND_API.G_MISS_NUM)
382: , nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)
383: , nvl(Configuration_ID, FND_API.G_MISS_NUM)
384: , ship_to_customer_name
385: , ship_to_customer_number

Line 382: , nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)

378: -- , Bill_to_Contact_Ref
379: -- , Deliver_to_Contact_Ref
380: -- End add new columns to select for the Add Customer}
381: , nvl(Config_Header_Id, FND_API.G_MISS_NUM)
382: , nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)
383: , nvl(Configuration_ID, FND_API.G_MISS_NUM)
384: , ship_to_customer_name
385: , ship_to_customer_number
386: , nvl(ship_to_customer_id, FND_API.G_MISS_NUM)

Line 383: , nvl(Configuration_ID, FND_API.G_MISS_NUM)

379: -- , Deliver_to_Contact_Ref
380: -- End add new columns to select for the Add Customer}
381: , nvl(Config_Header_Id, FND_API.G_MISS_NUM)
382: , nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)
383: , nvl(Configuration_ID, FND_API.G_MISS_NUM)
384: , ship_to_customer_name
385: , ship_to_customer_number
386: , nvl(ship_to_customer_id, FND_API.G_MISS_NUM)
387: , invoice_to_customer_name

Line 386: , nvl(ship_to_customer_id, FND_API.G_MISS_NUM)

382: , nvl(Config_Rev_Nbr, FND_API.G_MISS_NUM)
383: , nvl(Configuration_ID, FND_API.G_MISS_NUM)
384: , ship_to_customer_name
385: , ship_to_customer_number
386: , nvl(ship_to_customer_id, FND_API.G_MISS_NUM)
387: , invoice_to_customer_name
388: , invoice_to_customer_number
389: , nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)
390: , deliver_to_customer_name

Line 389: , nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)

385: , ship_to_customer_number
386: , nvl(ship_to_customer_id, FND_API.G_MISS_NUM)
387: , invoice_to_customer_name
388: , invoice_to_customer_number
389: , nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)
390: , deliver_to_customer_name
391: , deliver_to_customer_number
392: , nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)
393: , nvl(user_item_description, FND_API.G_MISS_CHAR)

Line 392: , nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)

388: , invoice_to_customer_number
389: , nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)
390: , deliver_to_customer_name
391: , deliver_to_customer_number
392: , nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)
393: , nvl(user_item_description, FND_API.G_MISS_CHAR)
394: , override_atp_date_code
395: , xml_transaction_type_code
396: , nvl(blanket_number, FND_API.G_MISS_NUM)

Line 393: , nvl(user_item_description, FND_API.G_MISS_CHAR)

389: , nvl(invoice_to_customer_id, FND_API.G_MISS_NUM)
390: , deliver_to_customer_name
391: , deliver_to_customer_number
392: , nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)
393: , nvl(user_item_description, FND_API.G_MISS_CHAR)
394: , override_atp_date_code
395: , xml_transaction_type_code
396: , nvl(blanket_number, FND_API.G_MISS_NUM)
397: , nvl(blanket_line_number, FND_API.G_MISS_NUM)

Line 396: , nvl(blanket_number, FND_API.G_MISS_NUM)

392: , nvl(deliver_to_customer_id, FND_API.G_MISS_NUM)
393: , nvl(user_item_description, FND_API.G_MISS_CHAR)
394: , override_atp_date_code
395: , xml_transaction_type_code
396: , nvl(blanket_number, FND_API.G_MISS_NUM)
397: , nvl(blanket_line_number, FND_API.G_MISS_NUM)
398: , shipping_method
399: FROM oe_lines_interface
400: WHERE order_source_id = l_order_source_id

Line 397: , nvl(blanket_line_number, FND_API.G_MISS_NUM)

393: , nvl(user_item_description, FND_API.G_MISS_CHAR)
394: , override_atp_date_code
395: , xml_transaction_type_code
396: , nvl(blanket_number, FND_API.G_MISS_NUM)
397: , nvl(blanket_line_number, FND_API.G_MISS_NUM)
398: , shipping_method
399: FROM oe_lines_interface
400: WHERE order_source_id = l_order_source_id
401: AND orig_sys_document_ref = l_orig_sys_document_ref

Line 410: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

406: OR decode(l_customer_key_profile, 'Y',
407: nvl(sold_to_org, ' '), '')
408: = decode(l_customer_key_profile, 'Y',
409: nvl(p_sold_to_org, ' '), ''))
410: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
411: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
412: AND request_id = l_request_id
413: AND nvl(rejected_flag, 'N') = 'Y'
414: ;

Line 411: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)

407: nvl(sold_to_org, ' '), '')
408: = decode(l_customer_key_profile, 'Y',
409: nvl(p_sold_to_org, ' '), ''))
410: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
411: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
412: AND request_id = l_request_id
413: AND nvl(rejected_flag, 'N') = 'Y'
414: ;
415:

Line 421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)

417: Line Lot Serials cursor
418: -----------------------------------------------------------
419: */
420: CURSOR l_lot_serial_cursor IS
421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)

Line 422: , nvl(change_request_code, FND_API.G_MISS_CHAR)

418: -----------------------------------------------------------
419: */
420: CURSOR l_lot_serial_cursor IS
421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)

Line 423: , nvl(lot_number, FND_API.G_MISS_CHAR)

419: */
420: CURSOR l_lot_serial_cursor IS
421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)

Line 424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)

420: CURSOR l_lot_serial_cursor IS
421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)

Line 425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)

421: SELECT nvl(orig_sys_lotserial_ref, FND_API.G_MISS_CHAR)
422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)

Line 426: , nvl(quantity, FND_API.G_MISS_NUM)

422: , nvl(change_request_code, FND_API.G_MISS_CHAR)
423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)

Line 427: , nvl(context, FND_API.G_MISS_CHAR)

423: , nvl(lot_number, FND_API.G_MISS_CHAR)
424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)

Line 428: , nvl(attribute1, FND_API.G_MISS_CHAR)

424: , nvl(from_serial_number, FND_API.G_MISS_CHAR)
425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)

Line 429: , nvl(attribute2, FND_API.G_MISS_CHAR)

425: , nvl(to_serial_number, FND_API.G_MISS_CHAR)
426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)

Line 430: , nvl(attribute3, FND_API.G_MISS_CHAR)

426: , nvl(quantity, FND_API.G_MISS_NUM)
427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)

Line 431: , nvl(attribute4, FND_API.G_MISS_CHAR)

427: , nvl(context, FND_API.G_MISS_CHAR)
428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)

Line 432: , nvl(attribute5, FND_API.G_MISS_CHAR)

428: , nvl(attribute1, FND_API.G_MISS_CHAR)
429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)

Line 433: , nvl(attribute6, FND_API.G_MISS_CHAR)

429: , nvl(attribute2, FND_API.G_MISS_CHAR)
430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)

Line 434: , nvl(attribute7, FND_API.G_MISS_CHAR)

430: , nvl(attribute3, FND_API.G_MISS_CHAR)
431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)

Line 435: , nvl(attribute8, FND_API.G_MISS_CHAR)

431: , nvl(attribute4, FND_API.G_MISS_CHAR)
432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)

Line 436: , nvl(attribute9, FND_API.G_MISS_CHAR)

432: , nvl(attribute5, FND_API.G_MISS_CHAR)
433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)

Line 437: , nvl(attribute10, FND_API.G_MISS_CHAR)

433: , nvl(attribute6, FND_API.G_MISS_CHAR)
434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)

Line 438: , nvl(attribute11, FND_API.G_MISS_CHAR)

434: , nvl(attribute7, FND_API.G_MISS_CHAR)
435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)
442: , nvl(attribute15, FND_API.G_MISS_CHAR)

Line 439: , nvl(attribute12, FND_API.G_MISS_CHAR)

435: , nvl(attribute8, FND_API.G_MISS_CHAR)
436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)
442: , nvl(attribute15, FND_API.G_MISS_CHAR)
443: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

Line 440: , nvl(attribute13, FND_API.G_MISS_CHAR)

436: , nvl(attribute9, FND_API.G_MISS_CHAR)
437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)
442: , nvl(attribute15, FND_API.G_MISS_CHAR)
443: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
444: FROM oe_lotserials_interface

Line 441: , nvl(attribute14, FND_API.G_MISS_CHAR)

437: , nvl(attribute10, FND_API.G_MISS_CHAR)
438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)
442: , nvl(attribute15, FND_API.G_MISS_CHAR)
443: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
444: FROM oe_lotserials_interface
445: WHERE order_source_id = l_order_source_id

Line 442: , nvl(attribute15, FND_API.G_MISS_CHAR)

438: , nvl(attribute11, FND_API.G_MISS_CHAR)
439: , nvl(attribute12, FND_API.G_MISS_CHAR)
440: , nvl(attribute13, FND_API.G_MISS_CHAR)
441: , nvl(attribute14, FND_API.G_MISS_CHAR)
442: , nvl(attribute15, FND_API.G_MISS_CHAR)
443: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
444: FROM oe_lotserials_interface
445: WHERE order_source_id = l_order_source_id
446: AND orig_sys_document_ref = l_orig_sys_document_ref

Line 455: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

451: OR decode(l_customer_key_profile, 'Y',
452: nvl(sold_to_org, ' '), '')
453: = decode(l_customer_key_profile, 'Y',
454: nvl(p_sold_to_org, ' '), ''))
455: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
456: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
457: AND orig_sys_line_ref = l_orig_sys_line_ref
458: AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
459: = nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)

Line 456: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)

452: nvl(sold_to_org, ' '), '')
453: = decode(l_customer_key_profile, 'Y',
454: nvl(p_sold_to_org, ' '), ''))
455: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
456: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
457: AND orig_sys_line_ref = l_orig_sys_line_ref
458: AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
459: = nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
460: AND request_id = p_request_id

Line 458: AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)

454: nvl(p_sold_to_org, ' '), ''))
455: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
456: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
457: AND orig_sys_line_ref = l_orig_sys_line_ref
458: AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
459: = nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
460: AND request_id = p_request_id
461: ;
462:

Line 459: = nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)

455: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
456: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
457: AND orig_sys_line_ref = l_orig_sys_line_ref
458: AND nvl(orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
459: = nvl(l_orig_sys_shipment_ref, FND_API.G_MISS_CHAR)
460: AND request_id = p_request_id
461: ;
462:
463: --

Line 947: x_return_status := FND_API.G_RET_STS_SUCCESS;

943: x_rejected_lot_serial_tbl := l_lot_serial_tbl;
944: END IF;
945: END IF;
946:
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949:
950: EXCEPTION
951: WHEN OTHERS THEN

Line 956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'ENCOUNTERED OTHERS ERROR EXCEPTION IN OE_REJECTED_LINES_ACK.GET_REJECTED_LINES: '||SQLERRM ) ;
954: END IF;
955:
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
957:
958: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
959: THEN
960: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);