39: /*--------------------------------------------------*/
40:
41: TYPE OM_INTERFACE_REC IS RECORD
42: (
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
40:
41: TYPE OM_INTERFACE_REC IS RECORD
42: (
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
41: TYPE OM_INTERFACE_REC IS RECORD
42: (
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
42: (
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
44: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
45: ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
46: ORG_ID NUMBER := FND_API.G_MISS_NUM,
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
55: );
48: ORDER_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
55: );
56:
49: PICKING_RULE_ID NUMBER := FND_API.G_MISS_NUM,
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:
50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54: LOCATOR_ID NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:
58: /*--------------------------------------------------*/
62: /*--------------------------------------------------*/
63:
64: TYPE service_request_rec IS RECORD
65: (
66: request_date DATE := FND_API.G_MISS_DATE,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
63:
64: TYPE service_request_rec IS RECORD
65: (
66: request_date DATE := FND_API.G_MISS_DATE,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
64: TYPE service_request_rec IS RECORD
65: (
66: request_date DATE := FND_API.G_MISS_DATE,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: (
66: request_date DATE := FND_API.G_MISS_DATE,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
66: request_date DATE := FND_API.G_MISS_DATE,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: type_id NUMBER := FND_API.G_MISS_NUM,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
69: status_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: severity_id NUMBER := FND_API.G_MISS_NUM,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: urgency_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: closed_date DATE := FND_API.G_MISS_DATE,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
76: owner_id NUMBER := FND_API.G_MISS_NUM,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: owner_group_id NUMBER := FND_API.G_MISS_NUM,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
79: summary VARCHAR2(240):= FND_API.G_MISS_CHAR,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
81: customer_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
82: customer_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
83: employee_id NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
84: employee_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
86: customer_product_id NUMBER := FND_API.G_MISS_NUM,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
90: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
91: original_order_number NUMBER := FND_API.G_MISS_NUM,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
94: exp_resolution_date DATE := FND_API.G_MISS_DATE,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
96: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
97: contract_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
98: account_id NUMBER := FND_API.G_MISS_NUM,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
99: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
101: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: incident_number VARCHAR2(64) := NULL, -- swai: FP 5157216
103: sr_contact_point_id NUMBER := FND_API.G_MISS_NUM,
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: incident_number VARCHAR2(64) := NULL, -- swai: FP 5157216
111: /*Fixed for bug#5589395 below column added for DFF on SR*/
104: party_id NUMBER := FND_API.G_MISS_NUM,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: incident_number VARCHAR2(64) := NULL, -- swai: FP 5157216
111: /*Fixed for bug#5589395 below column added for DFF on SR*/
112: external_context VARCHAR2(30):=NULL,
105: contact_point_id NUMBER := FND_API.G_MISS_NUM,
106: contact_point_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
110: incident_number VARCHAR2(64) := NULL, -- swai: FP 5157216
111: /*Fixed for bug#5589395 below column added for DFF on SR*/
112: external_context VARCHAR2(30):=NULL,
113: external_attribute_1 VARCHAR2(150):=NULL,
151:
152:
153: TYPE PRODUCT_TXN_REC IS RECORD
154: (
155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
152:
153: TYPE PRODUCT_TXN_REC IS RECORD
154: (
155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
153: TYPE PRODUCT_TXN_REC IS RECORD
154: (
155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
154: (
155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
156: repair_line_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
157: estimate_detail_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
160: incident_id NUMBER := FND_API.G_MISS_NUM,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
161: transaction_type_id NUMBER := FND_API.G_MISS_NUM,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
162: business_process_id NUMBER := FND_API.G_MISS_NUM,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
163: txn_billing_type_id NUMBER := FND_API.G_MISS_NUM,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
164: original_source_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
165: source_id NUMBER := FND_API.G_MISS_NUM,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
166: line_type_id NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
167: order_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
168: status VARCHAR2(30) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,
171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
178: -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
173: revision VARCHAR2(10) := FND_API.G_MISS_CHAR,
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
178: -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
174: quantity NUMBER := FND_API.G_MISS_NUM,
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
178: -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
175: -- ( comented serial_number as it is replaced by Source_Serial_Number 11.5.10
176: -- serial_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
178: -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
177: -- (commented shipped_serial_number it is no more used from 11.5.10
178: -- shipped_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
180: -- (Commented instance_id as it is replaced by Source_instance_id 11.5.10
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
183: -- instance_number NUMBER := FND_API.G_MISS_NUM,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
184: price_list_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
185: contract_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
186: coverage_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
187: coverage_txn_group_id NUMBER := FND_API.G_MISS_NUM,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
188: coverage_bill_rate_id NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
189: order_header_id NUMBER := FND_API.G_MISS_NUM,
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
190: order_line_id NUMBER := FND_API.G_MISS_NUM,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
192: organization_id NUMBER := FND_API.G_MISS_NUM,
193: invoice_to_org_id NUMBER := FND_API.G_MISS_NUM,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
194: ship_to_org_id NUMBER := FND_API.G_MISS_NUM,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
195: no_charge_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
197: add_to_order_flag VARCHAR2(1) := 'F',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
199: interface_to_om_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
200: book_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
201: release_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
202: ship_sales_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
203: prod_txn_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
205: process_txn_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
206: return_reason VARCHAR2(30) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
207: return_by_date DATE := FND_API.G_MISS_DATE,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
208: last_update_date DATE := FND_API.G_MISS_DATE,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
209: creation_date DATE := FND_API.G_MISS_DATE,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
211: created_by NUMBER := FND_API.G_MISS_NUM,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
212: last_update_login NUMBER := FND_API.G_MISS_NUM,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
213: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
214: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
215: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
216: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
217: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
218: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
219: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
220: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
221: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
222: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
223: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
224: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232: -- Following columns are added as part of 11.5.10 release enhancments
225: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232: -- Following columns are added as part of 11.5.10 release enhancments
233: -- Non source columns will be used only when repair type in
226: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232: -- Following columns are added as part of 11.5.10 release enhancments
233: -- Non source columns will be used only when repair type in
234: --(Replacement, Exchange and Advance Exchange)
227: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
228: context VARCHAR2(30) := FND_API.G_MISS_CHAR,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232: -- Following columns are added as part of 11.5.10 release enhancments
233: -- Non source columns will be used only when repair type in
234: --(Replacement, Exchange and Advance Exchange)
235: non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
232: -- Following columns are added as part of 11.5.10 release enhancments
233: -- Non source columns will be used only when repair type in
234: --(Replacement, Exchange and Advance Exchange)
235: non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
236: non_source_instance_Number VARCHAR2(30) := NULL ,
237: non_source_instance_id NUMBER := FND_API.G_MISS_NUM,
238: source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
233: -- Non source columns will be used only when repair type in
234: --(Replacement, Exchange and Advance Exchange)
235: non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
236: non_source_instance_Number VARCHAR2(30) := NULL ,
237: non_source_instance_id NUMBER := FND_API.G_MISS_NUM,
238: source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
240: source_instance_number VARCHAR2(30) := NULL,
241: source_instance_id NUMBER := FND_API.G_MISS_NUM,
234: --(Replacement, Exchange and Advance Exchange)
235: non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
236: non_source_instance_Number VARCHAR2(30) := NULL ,
237: non_source_instance_id NUMBER := FND_API.G_MISS_NUM,
238: source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
240: source_instance_number VARCHAR2(30) := NULL,
241: source_instance_id NUMBER := FND_API.G_MISS_NUM,
242: -- Requisition columns are used only for internal RO
237: non_source_instance_id NUMBER := FND_API.G_MISS_NUM,
238: source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
239: -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
240: source_instance_number VARCHAR2(30) := NULL,
241: source_instance_id NUMBER := FND_API.G_MISS_NUM,
242: -- Requisition columns are used only for internal RO
243: req_header_id NUMBER := FND_API.G_MISS_NUM,
244: req_line_id NUMBER := FND_API.G_MISS_NUM,
245: -- Quantity received against RMA or internal so.
239: -- Since instance_number is defined as Number in Charges Record assigning NULL -- value instead of G_MISS_CHAR when initialized. saupadhy Sep-12-2003
240: source_instance_number VARCHAR2(30) := NULL,
241: source_instance_id NUMBER := FND_API.G_MISS_NUM,
242: -- Requisition columns are used only for internal RO
243: req_header_id NUMBER := FND_API.G_MISS_NUM,
244: req_line_id NUMBER := FND_API.G_MISS_NUM,
245: -- Quantity received against RMA or internal so.
246: prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
247: -- Quantity shipped against SHIP line or internal so.
240: source_instance_number VARCHAR2(30) := NULL,
241: source_instance_id NUMBER := FND_API.G_MISS_NUM,
242: -- Requisition columns are used only for internal RO
243: req_header_id NUMBER := FND_API.G_MISS_NUM,
244: req_line_id NUMBER := FND_API.G_MISS_NUM,
245: -- Quantity received against RMA or internal so.
246: prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
247: -- Quantity shipped against SHIP line or internal so.
248: prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
242: -- Requisition columns are used only for internal RO
243: req_header_id NUMBER := FND_API.G_MISS_NUM,
244: req_line_id NUMBER := FND_API.G_MISS_NUM,
245: -- Quantity received against RMA or internal so.
246: prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
247: -- Quantity shipped against SHIP line or internal so.
248: prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
249: -- sub_inventory_rcvd column used by Internal repair order
250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
244: req_line_id NUMBER := FND_API.G_MISS_NUM,
245: -- Quantity received against RMA or internal so.
246: prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
247: -- Quantity shipped against SHIP line or internal so.
248: prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
249: -- sub_inventory_rcvd column used by Internal repair order
250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
251: -- Lot_number_Rcvd column used by Internal repair order
252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
246: prd_txn_qty_received NUMBER := FND_API.G_MISS_NUM,
247: -- Quantity shipped against SHIP line or internal so.
248: prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
249: -- sub_inventory_rcvd column used by Internal repair order
250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
251: -- Lot_number_Rcvd column used by Internal repair order
252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
253: -- This column is used only by both regular and internal ROs, if item is locator controlled
254: locator_id NUMBER := FND_API.G_MISS_NUM,
248: prd_txn_qty_shipped NUMBER := FND_API.G_MISS_NUM,
249: -- sub_inventory_rcvd column used by Internal repair order
250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
251: -- Lot_number_Rcvd column used by Internal repair order
252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
253: -- This column is used only by both regular and internal ROs, if item is locator controlled
254: locator_id NUMBER := FND_API.G_MISS_NUM,
255: charge_line_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
256: -- Add_to_Order_Id column is used by regular RO only
250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,
251: -- Lot_number_Rcvd column used by Internal repair order
252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
253: -- This column is used only by both regular and internal ROs, if item is locator controlled
254: locator_id NUMBER := FND_API.G_MISS_NUM,
255: charge_line_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
256: -- Add_to_Order_Id column is used by regular RO only
257: add_to_order_id NUMBER := FND_API.G_MISS_NUM,
258: --Add below col for r12
251: -- Lot_number_Rcvd column used by Internal repair order
252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226
253: -- This column is used only by both regular and internal ROs, if item is locator controlled
254: locator_id NUMBER := FND_API.G_MISS_NUM,
255: charge_line_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
256: -- Add_to_Order_Id column is used by regular RO only
257: add_to_order_id NUMBER := FND_API.G_MISS_NUM,
258: --Add below col for r12
259: picking_rule_id NUMBER,
253: -- This column is used only by both regular and internal ROs, if item is locator controlled
254: locator_id NUMBER := FND_API.G_MISS_NUM,
255: charge_line_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
256: -- Add_to_Order_Id column is used by regular RO only
257: add_to_order_id NUMBER := FND_API.G_MISS_NUM,
258: --Add below col for r12
259: picking_rule_id NUMBER,
260: --R12 changes for contracts re arch
261: contract_line_id NUMBER,
263: -- table has this column, this may not be used.
264: -- inventory_org changes , vijay Jan 28, 2006
265: inventory_org_id NUMBER,
266: --taklam add column for project integration
267: project_id NUMBER := FND_API.G_MISS_NUM,
268: task_id NUMBER := FND_API.G_MISS_NUM,
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
264: -- inventory_org changes , vijay Jan 28, 2006
265: inventory_org_id NUMBER,
266: --taklam add column for project integration
267: project_id NUMBER := FND_API.G_MISS_NUM,
268: task_id NUMBER := FND_API.G_MISS_NUM,
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
265: inventory_org_id NUMBER,
266: --taklam add column for project integration
267: project_id NUMBER := FND_API.G_MISS_NUM,
268: task_id NUMBER := FND_API.G_MISS_NUM,
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
267: project_id NUMBER := FND_API.G_MISS_NUM,
268: task_id NUMBER := FND_API.G_MISS_NUM,
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275: -- swai: bug 6148019 internal PO Number
268: task_id NUMBER := FND_API.G_MISS_NUM,
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275: -- swai: bug 6148019 internal PO Number
276: internal_po_header_id NUMBER := FND_API.G_MISS_NUM
269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275: -- swai: bug 6148019 internal PO Number
276: internal_po_header_id NUMBER := FND_API.G_MISS_NUM
277: );
270: -- swai: bug 5931926 - 3rd party logistics for 12.0.2
271: bill_to_party_id NUMBER := FND_API.G_MISS_NUM,
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275: -- swai: bug 6148019 internal PO Number
276: internal_po_header_id NUMBER := FND_API.G_MISS_NUM
277: );
278:
272: bill_to_account_id NUMBER := FND_API.G_MISS_NUM,
273: ship_to_party_id NUMBER := FND_API.G_MISS_NUM,
274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,
275: -- swai: bug 6148019 internal PO Number
276: internal_po_header_id NUMBER := FND_API.G_MISS_NUM
277: );
278:
279: TYPE PRODUCT_TXN_TBL IS TABLE OF PRODUCT_TXN_REC INDEX BY BINARY_INTEGER;
280:
305: /* the Task called from Depot Repair Repair Forms */
306: /*-------------------------------------------------------*/
307: TYPE CREATE_TASK_REC_TYPE IS RECORD
308: (
309: TASK_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
306: /*-------------------------------------------------------*/
307: TYPE CREATE_TASK_REC_TYPE IS RECORD
308: (
309: TASK_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
307: TYPE CREATE_TASK_REC_TYPE IS RECORD
308: (
309: TASK_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
308: (
309: TASK_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
309: TASK_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
315: TASK_PRIORITY_ID NUMBER := FND_API.G_MISS_NUM,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
317: OWNER_ID NUMBER := FND_API.G_MISS_NUM,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
318: OWNER_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
319: ASSIGNED_BY_ID NUMBER := FND_API.G_MISS_NUM,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
320: CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
322: ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
323: PLANNED_START_DATE DATE := FND_API.G_MISS_DATE,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
325: SCHEDULED_START_DATE DATE := FND_API.G_MISS_DATE,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
328: ACTUAL_END_DATE DATE := FND_API.G_MISS_DATE,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
333: DURATION NUMBER := FND_API.G_MISS_NUM,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
336: PLANNED_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
338: ACTUAL_EFFORT_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
339: PRIVATE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
340: PUBLISH_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
342: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
343: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
344: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
345: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
346: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
347: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
348: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
349: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
350: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
351: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
352: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
353: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
354: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
355: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
363: );
356: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
363: );
364:
357: ATTRIBUTE_CATEGORY VARCHAR2(150) := FND_API.G_MISS_CHAR,
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
363: );
364:
365: /*---------------------------------------------------*/
358: BOUND_MODE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,
362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
363: );
364:
365: /*---------------------------------------------------*/
366: /* Function to Return the Record Type for Creating / */
376: /* Address called from Depot Repair Repair Forms */
377: /*---------------------------------------------------*/
378: TYPE address_rec_type IS RECORD
379: (
380: location_id NUMBER := FND_API.G_MISS_NUM,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
377: /*---------------------------------------------------*/
378: TYPE address_rec_type IS RECORD
379: (
380: location_id NUMBER := FND_API.G_MISS_NUM,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
378: TYPE address_rec_type IS RECORD
379: (
380: location_id NUMBER := FND_API.G_MISS_NUM,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
379: (
380: location_id NUMBER := FND_API.G_MISS_NUM,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
380: location_id NUMBER := FND_API.G_MISS_NUM,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
381: address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
382: address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
383: address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
384: address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
385: city VARCHAR2(60) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
386: state VARCHAR2(60) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
387: postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
388: province VARCHAR2(60) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
389: county VARCHAR2(60) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
390: country VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
391: language VARCHAR2(4) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
392: position VARCHAR2(50) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
393: address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
395: delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
396: location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
397: -- address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
398: clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
399: short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
400: description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
402: sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
403: address_effective_date DATE := FND_API.G_MISS_DATE,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
406: /* swai: unused TCA fields per bug #2863096, but still avail in TCA */
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
407: po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
408: house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
409: street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
410: street VARCHAR2(50) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
412: floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
413: suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
414: /* swai: obsoleted TCA v1 fields
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
415: apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
416: apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
420: building VARCHAR2(50) := FND_API.G_MISS_CHAR,
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
428: */
421: room VARCHAR2(50) := FND_API.G_MISS_CHAR,
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
428: */
429: /* swai: new TCA v2 fields */
422: time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
428: */
429: /* swai: new TCA v2 fields */
430: timezone_id NUMBER := FND_API.G_MISS_NUM,
423: post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
424: dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
425: trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
428: */
429: /* swai: new TCA v2 fields */
430: timezone_id NUMBER := FND_API.G_MISS_NUM,
431: created_by_module VARCHAR2(150) := 'CSDSR',
426: life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
427: wh_update_date DATE := FND_API.G_MISS_DATE
428: */
429: /* swai: new TCA v2 fields */
430: timezone_id NUMBER := FND_API.G_MISS_NUM,
431: created_by_module VARCHAR2(150) := 'CSDSR',
432: application_id NUMBER := 516,
433: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
434: );
429: /* swai: new TCA v2 fields */
430: timezone_id NUMBER := FND_API.G_MISS_NUM,
431: created_by_module VARCHAR2(150) := 'CSDSR',
432: application_id NUMBER := 516,
433: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR
434: );
435:
436:
437: /*---------------------------------------------------*/
470: /*--------------------------------------------------*/
471:
472: procedure PROCESS_SERVICE_REQUEST
473: ( p_api_version IN NUMBER,
474: p_commit IN VARCHAR2 := fnd_api.g_false,
475: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
476: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
477: p_action IN VARCHAR2,
478: p_incident_id IN NUMBER := NULL,
471:
472: procedure PROCESS_SERVICE_REQUEST
473: ( p_api_version IN NUMBER,
474: p_commit IN VARCHAR2 := fnd_api.g_false,
475: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
476: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
477: p_action IN VARCHAR2,
478: p_incident_id IN NUMBER := NULL,
479: p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
472: procedure PROCESS_SERVICE_REQUEST
473: ( p_api_version IN NUMBER,
474: p_commit IN VARCHAR2 := fnd_api.g_false,
475: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
476: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
477: p_action IN VARCHAR2,
478: p_incident_id IN NUMBER := NULL,
479: p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
480: p_notes_tbl IN CS_SERVICEREQUEST_PUB.NOTES_TABLE ,
492: /*--------------------------------------------------*/
493:
494: procedure PROCESS_SERVICE_REQUEST
495: ( p_api_version IN NUMBER,
496: p_commit IN VARCHAR2 := fnd_api.g_false,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
499: p_action IN VARCHAR2,
500: p_incident_id IN NUMBER := NULL,
493:
494: procedure PROCESS_SERVICE_REQUEST
495: ( p_api_version IN NUMBER,
496: p_commit IN VARCHAR2 := fnd_api.g_false,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
499: p_action IN VARCHAR2,
500: p_incident_id IN NUMBER := NULL,
501: p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
494: procedure PROCESS_SERVICE_REQUEST
495: ( p_api_version IN NUMBER,
496: p_commit IN VARCHAR2 := fnd_api.g_false,
497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
499: p_action IN VARCHAR2,
500: p_incident_id IN NUMBER := NULL,
501: p_service_request_rec IN CSD_PROCESS_PVT.SERVICE_REQUEST_REC,
502: x_incident_id OUT NOCOPY NUMBER,
514: /*--------------------------------------------------*/
515:
516: procedure PROCESS_CHARGE_LINES
517: ( p_api_version IN NUMBER,
518: p_commit IN VARCHAR2 := fnd_api.g_false,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
520: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
521: p_action IN VARCHAR2,
522: p_Charges_Rec IN Cs_Charge_Details_Pub.Charges_Rec_Type,
515:
516: procedure PROCESS_CHARGE_LINES
517: ( p_api_version IN NUMBER,
518: p_commit IN VARCHAR2 := fnd_api.g_false,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
520: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
521: p_action IN VARCHAR2,
522: p_Charges_Rec IN Cs_Charge_Details_Pub.Charges_Rec_Type,
523: x_estimate_detail_id OUT NOCOPY NUMBER,
516: procedure PROCESS_CHARGE_LINES
517: ( p_api_version IN NUMBER,
518: p_commit IN VARCHAR2 := fnd_api.g_false,
519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
520: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
521: p_action IN VARCHAR2,
522: p_Charges_Rec IN Cs_Charge_Details_Pub.Charges_Rec_Type,
523: x_estimate_detail_id OUT NOCOPY NUMBER,
524: x_return_status OUT NOCOPY VARCHAR2,
533: /*--------------------------------------------------*/
534:
535: procedure APPLY_CONTRACT
536: ( p_api_version IN NUMBER,
537: p_commit IN VARCHAR2 := fnd_api.g_false,
538: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
539: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
540: p_incident_id IN NUMBER,
541: x_return_status OUT NOCOPY VARCHAR2,
534:
535: procedure APPLY_CONTRACT
536: ( p_api_version IN NUMBER,
537: p_commit IN VARCHAR2 := fnd_api.g_false,
538: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
539: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
540: p_incident_id IN NUMBER,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
535: procedure APPLY_CONTRACT
536: ( p_api_version IN NUMBER,
537: p_commit IN VARCHAR2 := fnd_api.g_false,
538: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
539: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
540: p_incident_id IN NUMBER,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2);
550: /*--------------------------------------------------*/
551:
552: procedure SHIP_SALES_ORDER
553: ( p_api_version IN NUMBER,
554: p_commit IN VARCHAR2 := fnd_api.g_false,
555: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
556: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
557: p_delivery_id IN OUT NOCOPY NUMBER,
558: x_return_status OUT NOCOPY VARCHAR2,
551:
552: procedure SHIP_SALES_ORDER
553: ( p_api_version IN NUMBER,
554: p_commit IN VARCHAR2 := fnd_api.g_false,
555: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
556: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
557: p_delivery_id IN OUT NOCOPY NUMBER,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
552: procedure SHIP_SALES_ORDER
553: ( p_api_version IN NUMBER,
554: p_commit IN VARCHAR2 := fnd_api.g_false,
555: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
556: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
557: p_delivery_id IN OUT NOCOPY NUMBER,
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2 );
568: /*--------------------------------------------------*/
569:
570: procedure PROCESS_SALES_ORDER
571: ( p_api_version IN NUMBER,
572: p_commit IN VARCHAR2 := fnd_api.g_false,
573: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
574: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
575: p_action IN VARCHAR2,
576: /*Fixed for bug#4433942 added product
569:
570: procedure PROCESS_SALES_ORDER
571: ( p_api_version IN NUMBER,
572: p_commit IN VARCHAR2 := fnd_api.g_false,
573: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
574: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
575: p_action IN VARCHAR2,
576: /*Fixed for bug#4433942 added product
577: txn record as in parameter
570: procedure PROCESS_SALES_ORDER
571: ( p_api_version IN NUMBER,
572: p_commit IN VARCHAR2 := fnd_api.g_false,
573: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
574: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
575: p_action IN VARCHAR2,
576: /*Fixed for bug#4433942 added product
577: txn record as in parameter
578: */
590: /*--------------------------------------------------*/
591:
592: procedure CREATE_PRODUCT_TXN
593: ( p_api_version IN NUMBER,
594: p_commit IN VARCHAR2 := fnd_api.g_false,
595: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
596: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
597: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
598: x_return_status OUT NOCOPY VARCHAR2,
591:
592: procedure CREATE_PRODUCT_TXN
593: ( p_api_version IN NUMBER,
594: p_commit IN VARCHAR2 := fnd_api.g_false,
595: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
596: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
597: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
592: procedure CREATE_PRODUCT_TXN
593: ( p_api_version IN NUMBER,
594: p_commit IN VARCHAR2 := fnd_api.g_false,
595: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
596: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
597: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
600: x_msg_data OUT NOCOPY VARCHAR2 );
625: /*--------------------------------------------------*/
626:
627: procedure UPDATE_PRODUCT_TXN
628: ( p_api_version IN NUMBER,
629: p_commit IN VARCHAR2 := fnd_api.g_false,
630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
632: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
633: x_return_status OUT NOCOPY VARCHAR2,
626:
627: procedure UPDATE_PRODUCT_TXN
628: ( p_api_version IN NUMBER,
629: p_commit IN VARCHAR2 := fnd_api.g_false,
630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
632: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
627: procedure UPDATE_PRODUCT_TXN
628: ( p_api_version IN NUMBER,
629: p_commit IN VARCHAR2 := fnd_api.g_false,
630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
631: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
632: x_product_txn_rec IN OUT NOCOPY PRODUCT_TXN_REC,
633: x_return_status OUT NOCOPY VARCHAR2,
634: x_msg_count OUT NOCOPY NUMBER,
635: x_msg_data OUT NOCOPY VARCHAR2 );
643: /*--------------------------------------------------*/
644:
645: Procedure DELETE_PRODUCT_TXN
646: ( p_api_version IN NUMBER,
647: p_commit IN VARCHAR2 := fnd_api.g_false,
648: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
649: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
650: p_product_txn_id IN NUMBER,
651: x_return_status OUT NOCOPY VARCHAR2,
644:
645: Procedure DELETE_PRODUCT_TXN
646: ( p_api_version IN NUMBER,
647: p_commit IN VARCHAR2 := fnd_api.g_false,
648: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
649: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
650: p_product_txn_id IN NUMBER,
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
645: Procedure DELETE_PRODUCT_TXN
646: ( p_api_version IN NUMBER,
647: p_commit IN VARCHAR2 := fnd_api.g_false,
648: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
649: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
650: p_product_txn_id IN NUMBER,
651: x_return_status OUT NOCOPY VARCHAR2,
652: x_msg_count OUT NOCOPY NUMBER,
653: x_msg_data OUT NOCOPY VARCHAR2 );
660: /*--------------------------------------------------*/
661:
662: procedure CREATE_DEFAULT_PROD_TXN
663: ( p_api_version IN NUMBER,
664: p_commit IN VARCHAR2 := fnd_api.g_false,
665: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
666: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
667: p_repair_line_id IN NUMBER,
668: x_return_status OUT NOCOPY VARCHAR2,
661:
662: procedure CREATE_DEFAULT_PROD_TXN
663: ( p_api_version IN NUMBER,
664: p_commit IN VARCHAR2 := fnd_api.g_false,
665: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
666: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
667: p_repair_line_id IN NUMBER,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
662: procedure CREATE_DEFAULT_PROD_TXN
663: ( p_api_version IN NUMBER,
664: p_commit IN VARCHAR2 := fnd_api.g_false,
665: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
666: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
667: p_repair_line_id IN NUMBER,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
670: x_msg_data OUT NOCOPY VARCHAR2 );
676: /* procedure name: create_task */
677: /* description : procedure used to create task */
678: /* Called from : Depot Repair Form to Create Task */
679: /* Input Parm : p_api_version NUMBER Required Api Version number */
680: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
681: /* default value is fnd_api.g_false */
682: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
683: /* fnd_api.g_false */
684: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
677: /* description : procedure used to create task */
678: /* Called from : Depot Repair Form to Create Task */
679: /* Input Parm : p_api_version NUMBER Required Api Version number */
680: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
681: /* default value is fnd_api.g_false */
682: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
683: /* fnd_api.g_false */
684: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
685: /* validation steps must be done and which steps */
678: /* Called from : Depot Repair Form to Create Task */
679: /* Input Parm : p_api_version NUMBER Required Api Version number */
680: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
681: /* default value is fnd_api.g_false */
682: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
683: /* fnd_api.g_false */
684: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
685: /* validation steps must be done and which steps */
686: /* should be skipped. */
679: /* Input Parm : p_api_version NUMBER Required Api Version number */
680: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
681: /* default value is fnd_api.g_false */
682: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
683: /* fnd_api.g_false */
684: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
685: /* validation steps must be done and which steps */
686: /* should be skipped. */
687: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
685: /* validation steps must be done and which steps */
686: /* should be skipped. */
687: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
688: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
689: /* fnd_api.g_ret_sts_success (success) */
690: /* fnd_api.g_ret_sts_error (error) */
691: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
692: /* x_msg_count NUMBER Number of messages in the message stack */
693: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
686: /* should be skipped. */
687: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
688: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
689: /* fnd_api.g_ret_sts_success (success) */
690: /* fnd_api.g_ret_sts_error (error) */
691: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
692: /* x_msg_count NUMBER Number of messages in the message stack */
693: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
694: /* x_task_id NUMBER Task Id of the created Task */
687: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
688: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
689: /* fnd_api.g_ret_sts_success (success) */
690: /* fnd_api.g_ret_sts_error (error) */
691: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
692: /* x_msg_count NUMBER Number of messages in the message stack */
693: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
694: /* x_task_id NUMBER Task Id of the created Task */
695: /*-----------------------------------------------------------------------------------------------------------*/
694: /* x_task_id NUMBER Task Id of the created Task */
695: /*-----------------------------------------------------------------------------------------------------------*/
696: procedure CREATE_TASK
697: ( p_api_version IN NUMBER,
698: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
699: p_commit IN VARCHAR2 := fnd_api.g_false,
700: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
701: p_create_task_rec IN CREATE_TASK_REC_TYPE,
702: x_return_status OUT NOCOPY VARCHAR2,
695: /*-----------------------------------------------------------------------------------------------------------*/
696: procedure CREATE_TASK
697: ( p_api_version IN NUMBER,
698: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
699: p_commit IN VARCHAR2 := fnd_api.g_false,
700: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
701: p_create_task_rec IN CREATE_TASK_REC_TYPE,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
696: procedure CREATE_TASK
697: ( p_api_version IN NUMBER,
698: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
699: p_commit IN VARCHAR2 := fnd_api.g_false,
700: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
701: p_create_task_rec IN CREATE_TASK_REC_TYPE,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
704: x_msg_data OUT NOCOPY VARCHAR2,
709: /* procedure name: update_task */
710: /* description : procedure used to update task */
711: /* Called from : Depot Repair Form to Create Task */
712: /* Input Parm : p_api_version NUMBER Required Api Version number */
713: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
714: /* default value is fnd_api.g_false */
715: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
716: /* fnd_api.g_false */
717: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
710: /* description : procedure used to update task */
711: /* Called from : Depot Repair Form to Create Task */
712: /* Input Parm : p_api_version NUMBER Required Api Version number */
713: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
714: /* default value is fnd_api.g_false */
715: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
716: /* fnd_api.g_false */
717: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
718: /* validation steps must be done and which steps */
711: /* Called from : Depot Repair Form to Create Task */
712: /* Input Parm : p_api_version NUMBER Required Api Version number */
713: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
714: /* default value is fnd_api.g_false */
715: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
716: /* fnd_api.g_false */
717: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
718: /* validation steps must be done and which steps */
719: /* should be skipped. */
712: /* Input Parm : p_api_version NUMBER Required Api Version number */
713: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
714: /* default value is fnd_api.g_false */
715: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
716: /* fnd_api.g_false */
717: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
718: /* validation steps must be done and which steps */
719: /* should be skipped. */
720: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
718: /* validation steps must be done and which steps */
719: /* should be skipped. */
720: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
721: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
722: /* fnd_api.g_ret_sts_success (success) */
723: /* fnd_api.g_ret_sts_error (error) */
724: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
725: /* x_msg_count NUMBER Number of messages in the message stack */
726: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
719: /* should be skipped. */
720: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
721: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
722: /* fnd_api.g_ret_sts_success (success) */
723: /* fnd_api.g_ret_sts_error (error) */
724: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
725: /* x_msg_count NUMBER Number of messages in the message stack */
726: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
727: /*-----------------------------------------------------------------------------------------------------------*/
720: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
721: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
722: /* fnd_api.g_ret_sts_success (success) */
723: /* fnd_api.g_ret_sts_error (error) */
724: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
725: /* x_msg_count NUMBER Number of messages in the message stack */
726: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
727: /*-----------------------------------------------------------------------------------------------------------*/
728:
727: /*-----------------------------------------------------------------------------------------------------------*/
728:
729: procedure UPDATE_TASK
730: ( p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
732: p_commit IN VARCHAR2 := fnd_api.g_false,
733: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
734: p_create_task_rec IN CREATE_TASK_REC_TYPE,
735: x_return_status OUT NOCOPY VARCHAR2,
728:
729: procedure UPDATE_TASK
730: ( p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
732: p_commit IN VARCHAR2 := fnd_api.g_false,
733: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
734: p_create_task_rec IN CREATE_TASK_REC_TYPE,
735: x_return_status OUT NOCOPY VARCHAR2,
736: x_msg_count OUT NOCOPY NUMBER,
729: procedure UPDATE_TASK
730: ( p_api_version IN NUMBER,
731: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
732: p_commit IN VARCHAR2 := fnd_api.g_false,
733: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
734: p_create_task_rec IN CREATE_TASK_REC_TYPE,
735: x_return_status OUT NOCOPY VARCHAR2,
736: x_msg_count OUT NOCOPY NUMBER,
737: x_msg_data OUT NOCOPY VARCHAR2
743: /* description : procedure to create Address for the Contact */
744: /* Called from : Depot Repair Form to Create Address */
745: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
746: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
747: /* fnd_api.g_ret_sts_success (success) */
748: /* fnd_api.g_ret_sts_error (error) */
749: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
750: /* x_msg_count NUMBER Number of messages in the message stack */
751: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
744: /* Called from : Depot Repair Form to Create Address */
745: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
746: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
747: /* fnd_api.g_ret_sts_success (success) */
748: /* fnd_api.g_ret_sts_error (error) */
749: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
750: /* x_msg_count NUMBER Number of messages in the message stack */
751: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
752: /* x_location_id NUMBER Location ID of the Contacts address created */
745: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
746: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
747: /* fnd_api.g_ret_sts_success (success) */
748: /* fnd_api.g_ret_sts_error (error) */
749: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
750: /* x_msg_count NUMBER Number of messages in the message stack */
751: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
752: /* x_location_id NUMBER Location ID of the Contacts address created */
753: /*-----------------------------------------------------------------------------------------------------------*/
765: /* description : procedure used to create Repair Order history */
766: /* for task creation */
767: /* Called from : Depot Repair Form to Create Address */
768: /* Input Parm : p_api_version NUMBER Required Api Version number */
769: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
770: /* default value is fnd_api.g_false */
771: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
772: /* fnd_api.g_false */
773: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
766: /* for task creation */
767: /* Called from : Depot Repair Form to Create Address */
768: /* Input Parm : p_api_version NUMBER Required Api Version number */
769: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
770: /* default value is fnd_api.g_false */
771: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
772: /* fnd_api.g_false */
773: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
774: /* validation steps must be done and which steps */
767: /* Called from : Depot Repair Form to Create Address */
768: /* Input Parm : p_api_version NUMBER Required Api Version number */
769: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
770: /* default value is fnd_api.g_false */
771: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
772: /* fnd_api.g_false */
773: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
774: /* validation steps must be done and which steps */
775: /* should be skipped. */
768: /* Input Parm : p_api_version NUMBER Required Api Version number */
769: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
770: /* default value is fnd_api.g_false */
771: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
772: /* fnd_api.g_false */
773: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
774: /* validation steps must be done and which steps */
775: /* should be skipped. */
776: /* p_task_id NUMBER Required Task Id */
775: /* should be skipped. */
776: /* p_task_id NUMBER Required Task Id */
777: /* p_repair_line_id NUMBER Required Repair_line_id */
778: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
779: /* fnd_api.g_ret_sts_success (success) */
780: /* fnd_api.g_ret_sts_error (error) */
781: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
782: /* x_msg_count NUMBER Number of messages in the message stack */
783: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
776: /* p_task_id NUMBER Required Task Id */
777: /* p_repair_line_id NUMBER Required Repair_line_id */
778: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
779: /* fnd_api.g_ret_sts_success (success) */
780: /* fnd_api.g_ret_sts_error (error) */
781: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
782: /* x_msg_count NUMBER Number of messages in the message stack */
783: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
784: /*-----------------------------------------------------------------------------------------------------------*/
777: /* p_repair_line_id NUMBER Required Repair_line_id */
778: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
779: /* fnd_api.g_ret_sts_success (success) */
780: /* fnd_api.g_ret_sts_error (error) */
781: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
782: /* x_msg_count NUMBER Number of messages in the message stack */
783: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
784: /*-----------------------------------------------------------------------------------------------------------*/
785:
784: /*-----------------------------------------------------------------------------------------------------------*/
785:
786: PROCEDURE Create_repair_task_hist
787: ( p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
789: p_commit IN VARCHAR2 := fnd_api.g_false,
790: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
791: p_task_id IN NUMBER,
792: p_repair_line_id IN NUMBER,
785:
786: PROCEDURE Create_repair_task_hist
787: ( p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
789: p_commit IN VARCHAR2 := fnd_api.g_false,
790: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
791: p_task_id IN NUMBER,
792: p_repair_line_id IN NUMBER,
793: x_return_status OUT NOCOPY VARCHAR2,
786: PROCEDURE Create_repair_task_hist
787: ( p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
789: p_commit IN VARCHAR2 := fnd_api.g_false,
790: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
791: p_task_id IN NUMBER,
792: p_repair_line_id IN NUMBER,
793: x_return_status OUT NOCOPY VARCHAR2,
794: x_msg_count OUT NOCOPY NUMBER,
800: /* description : procedure used to create Repair Order history */
801: /* for task creation */
802: /* Called from : Depot Repair Form to Create Address */
803: /* Input Parm : p_api_version NUMBER Required Api Version number */
804: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
805: /* default value is fnd_api.g_false */
806: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
807: /* fnd_api.g_false */
808: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
801: /* for task creation */
802: /* Called from : Depot Repair Form to Create Address */
803: /* Input Parm : p_api_version NUMBER Required Api Version number */
804: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
805: /* default value is fnd_api.g_false */
806: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
807: /* fnd_api.g_false */
808: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
809: /* validation steps must be done and which steps */
802: /* Called from : Depot Repair Form to Create Address */
803: /* Input Parm : p_api_version NUMBER Required Api Version number */
804: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
805: /* default value is fnd_api.g_false */
806: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
807: /* fnd_api.g_false */
808: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
809: /* validation steps must be done and which steps */
810: /* should be skipped.
803: /* Input Parm : p_api_version NUMBER Required Api Version number */
804: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
805: /* default value is fnd_api.g_false */
806: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
807: /* fnd_api.g_false */
808: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
809: /* validation steps must be done and which steps */
810: /* should be skipped.
811: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
809: /* validation steps must be done and which steps */
810: /* should be skipped.
811: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
812: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
813: /* fnd_api.g_ret_sts_success (success) */
814: /* fnd_api.g_ret_sts_error (error) */
815: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
816: /* x_msg_count NUMBER Number of messages in the message stack */
817: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
810: /* should be skipped.
811: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
812: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
813: /* fnd_api.g_ret_sts_success (success) */
814: /* fnd_api.g_ret_sts_error (error) */
815: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
816: /* x_msg_count NUMBER Number of messages in the message stack */
817: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
818: /*-----------------------------------------------------------------------------------------------------------*/
811: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
812: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
813: /* fnd_api.g_ret_sts_success (success) */
814: /* fnd_api.g_ret_sts_error (error) */
815: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
816: /* x_msg_count NUMBER Number of messages in the message stack */
817: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
818: /*-----------------------------------------------------------------------------------------------------------*/
819:
818: /*-----------------------------------------------------------------------------------------------------------*/
819:
820: PROCEDURE Create_repair_task_hist
821: ( p_api_version IN NUMBER,
822: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
823: p_commit IN VARCHAR2 := fnd_api.g_false,
824: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
825: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
826: x_return_status OUT NOCOPY VARCHAR2,
819:
820: PROCEDURE Create_repair_task_hist
821: ( p_api_version IN NUMBER,
822: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
823: p_commit IN VARCHAR2 := fnd_api.g_false,
824: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
825: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
826: x_return_status OUT NOCOPY VARCHAR2,
827: x_msg_count OUT NOCOPY NUMBER,
820: PROCEDURE Create_repair_task_hist
821: ( p_api_version IN NUMBER,
822: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
823: p_commit IN VARCHAR2 := fnd_api.g_false,
824: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
825: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
826: x_return_status OUT NOCOPY VARCHAR2,
827: x_msg_count OUT NOCOPY NUMBER,
828: x_msg_data OUT NOCOPY VARCHAR2
834: /* description : procedure used to Update Repair Order history */
835: /* for task creation */
836: /* Called from : Depot Repair Form to update to Repair history */
837: /* Input Parm : p_api_version NUMBER Required Api Version number */
838: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
839: /* default value is fnd_api.g_false */
840: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
841: /* fnd_api.g_false */
842: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
835: /* for task creation */
836: /* Called from : Depot Repair Form to update to Repair history */
837: /* Input Parm : p_api_version NUMBER Required Api Version number */
838: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
839: /* default value is fnd_api.g_false */
840: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
841: /* fnd_api.g_false */
842: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
843: /* validation steps must be done and which steps */
836: /* Called from : Depot Repair Form to update to Repair history */
837: /* Input Parm : p_api_version NUMBER Required Api Version number */
838: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
839: /* default value is fnd_api.g_false */
840: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
841: /* fnd_api.g_false */
842: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
843: /* validation steps must be done and which steps */
844: /* should be skipped. */
837: /* Input Parm : p_api_version NUMBER Required Api Version number */
838: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
839: /* default value is fnd_api.g_false */
840: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
841: /* fnd_api.g_false */
842: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
843: /* validation steps must be done and which steps */
844: /* should be skipped. */
845: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
843: /* validation steps must be done and which steps */
844: /* should be skipped. */
845: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
846: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
847: /* fnd_api.g_ret_sts_success (success) */
848: /* fnd_api.g_ret_sts_error (error) */
849: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
850: /* x_msg_count NUMBER Number of messages in the message stack */
851: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
844: /* should be skipped. */
845: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
846: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
847: /* fnd_api.g_ret_sts_success (success) */
848: /* fnd_api.g_ret_sts_error (error) */
849: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
850: /* x_msg_count NUMBER Number of messages in the message stack */
851: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
852: /*-----------------------------------------------------------------------------------------------------------*/
845: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
846: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
847: /* fnd_api.g_ret_sts_success (success) */
848: /* fnd_api.g_ret_sts_error (error) */
849: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
850: /* x_msg_count NUMBER Number of messages in the message stack */
851: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
852: /*-----------------------------------------------------------------------------------------------------------*/
853:
853:
854: /*
855: PROCEDURE Update_repair_task_hist
856: ( p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
858: p_commit IN VARCHAR2 := fnd_api.g_false,
859: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
860: p_task_id IN NUMBER,
861: p_repair_line_id IN NUMBER,
854: /*
855: PROCEDURE Update_repair_task_hist
856: ( p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
858: p_commit IN VARCHAR2 := fnd_api.g_false,
859: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
860: p_task_id IN NUMBER,
861: p_repair_line_id IN NUMBER,
862: x_return_status OUT NOCOPY VARCHAR2,
855: PROCEDURE Update_repair_task_hist
856: ( p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
858: p_commit IN VARCHAR2 := fnd_api.g_false,
859: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
860: p_task_id IN NUMBER,
861: p_repair_line_id IN NUMBER,
862: x_return_status OUT NOCOPY VARCHAR2,
863: x_msg_count OUT NOCOPY NUMBER,
869: /* description : procedure used to Update Repair Order history */
870: /* for task creation */
871: /* Called from : Depot Repair Form to update to Repair history */
872: /* Input Parm : p_api_version NUMBER Required Api Version number */
873: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
874: /* default value is fnd_api.g_false */
875: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
876: /* fnd_api.g_false */
877: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
870: /* for task creation */
871: /* Called from : Depot Repair Form to update to Repair history */
872: /* Input Parm : p_api_version NUMBER Required Api Version number */
873: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
874: /* default value is fnd_api.g_false */
875: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
876: /* fnd_api.g_false */
877: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
878: /* validation steps must be done and which steps */
871: /* Called from : Depot Repair Form to update to Repair history */
872: /* Input Parm : p_api_version NUMBER Required Api Version number */
873: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
874: /* default value is fnd_api.g_false */
875: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
876: /* fnd_api.g_false */
877: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
878: /* validation steps must be done and which steps */
879: /* should be skipped. */
872: /* Input Parm : p_api_version NUMBER Required Api Version number */
873: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
874: /* default value is fnd_api.g_false */
875: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
876: /* fnd_api.g_false */
877: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
878: /* validation steps must be done and which steps */
879: /* should be skipped. */
880: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
878: /* validation steps must be done and which steps */
879: /* should be skipped. */
880: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
881: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
882: /* fnd_api.g_ret_sts_success (success) */
883: /* fnd_api.g_ret_sts_error (error) */
884: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
885: /* x_msg_count NUMBER Number of messages in the message stack */
886: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
879: /* should be skipped. */
880: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
881: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
882: /* fnd_api.g_ret_sts_success (success) */
883: /* fnd_api.g_ret_sts_error (error) */
884: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
885: /* x_msg_count NUMBER Number of messages in the message stack */
886: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
887: /*-----------------------------------------------------------------------------------------------------------*/
880: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
881: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
882: /* fnd_api.g_ret_sts_success (success) */
883: /* fnd_api.g_ret_sts_error (error) */
884: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
885: /* x_msg_count NUMBER Number of messages in the message stack */
886: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
887: /*-----------------------------------------------------------------------------------------------------------*/
888:
887: /*-----------------------------------------------------------------------------------------------------------*/
888:
889: PROCEDURE Update_repair_task_hist
890: ( p_api_version IN NUMBER,
891: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
892: p_commit IN VARCHAR2 := fnd_api.g_false,
893: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
894: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
895: x_return_status OUT NOCOPY VARCHAR2,
888:
889: PROCEDURE Update_repair_task_hist
890: ( p_api_version IN NUMBER,
891: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
892: p_commit IN VARCHAR2 := fnd_api.g_false,
893: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
894: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
895: x_return_status OUT NOCOPY VARCHAR2,
896: x_msg_count OUT NOCOPY NUMBER,
889: PROCEDURE Update_repair_task_hist
890: ( p_api_version IN NUMBER,
891: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
892: p_commit IN VARCHAR2 := fnd_api.g_false,
893: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
894: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
895: x_return_status OUT NOCOPY VARCHAR2,
896: x_msg_count OUT NOCOPY NUMBER,
897: x_msg_data OUT NOCOPY VARCHAR2
904: /*----------------------------------------------------------------*/
905:
906: PROCEDURE Close_status
907: ( p_api_version IN NUMBER,
908: p_commit IN VARCHAR2 := fnd_api.g_false,
909: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
910: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
911: p_incident_id IN NUMBER,
912: p_repair_line_id IN NUMBER,
905:
906: PROCEDURE Close_status
907: ( p_api_version IN NUMBER,
908: p_commit IN VARCHAR2 := fnd_api.g_false,
909: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
910: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
911: p_incident_id IN NUMBER,
912: p_repair_line_id IN NUMBER,
913: x_return_status OUT NOCOPY VARCHAR2,
906: PROCEDURE Close_status
907: ( p_api_version IN NUMBER,
908: p_commit IN VARCHAR2 := fnd_api.g_false,
909: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
910: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
911: p_incident_id IN NUMBER,
912: p_repair_line_id IN NUMBER,
913: x_return_status OUT NOCOPY VARCHAR2,
914: x_msg_count OUT NOCOPY NUMBER,
921: /* RMA/SO lines for the given service request */
922: /*---------------------------------------------------------------*/
923: PROCEDURE Check_Service_Request
924: ( p_api_version IN NUMBER,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
928: p_incident_id IN NUMBER,
929: x_link_mode OUT NOCOPY NUMBER,
922: /*---------------------------------------------------------------*/
923: PROCEDURE Check_Service_Request
924: ( p_api_version IN NUMBER,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
928: p_incident_id IN NUMBER,
929: x_link_mode OUT NOCOPY NUMBER,
930: x_return_status OUT NOCOPY VARCHAR2,
923: PROCEDURE Check_Service_Request
924: ( p_api_version IN NUMBER,
925: p_commit IN VARCHAR2 := fnd_api.g_false,
926: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
927: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
928: p_incident_id IN NUMBER,
929: x_link_mode OUT NOCOPY NUMBER,
930: x_return_status OUT NOCOPY VARCHAR2,
931: x_msg_count OUT NOCOPY NUMBER,
1024: /* procedure name: create_repair_task */
1025: /* description : procedure used to create DR specific tasks in Depot tables */
1026: /* Called from : Depot Repair Form to Create Task */
1027: /* Input Parm : p_api_version NUMBER Required Api Version number */
1028: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1029: /* default value is fnd_api.g_false */
1030: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1031: /* fnd_api.g_false */
1032: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1025: /* description : procedure used to create DR specific tasks in Depot tables */
1026: /* Called from : Depot Repair Form to Create Task */
1027: /* Input Parm : p_api_version NUMBER Required Api Version number */
1028: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1029: /* default value is fnd_api.g_false */
1030: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1031: /* fnd_api.g_false */
1032: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1033: /* validation steps must be done and which steps */
1026: /* Called from : Depot Repair Form to Create Task */
1027: /* Input Parm : p_api_version NUMBER Required Api Version number */
1028: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1029: /* default value is fnd_api.g_false */
1030: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1031: /* fnd_api.g_false */
1032: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1033: /* validation steps must be done and which steps */
1034: /* should be skipped. */
1027: /* Input Parm : p_api_version NUMBER Required Api Version number */
1028: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1029: /* default value is fnd_api.g_false */
1030: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1031: /* fnd_api.g_false */
1032: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1033: /* validation steps must be done and which steps */
1034: /* should be skipped. */
1035: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1033: /* validation steps must be done and which steps */
1034: /* should be skipped. */
1035: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1036: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1037: /* fnd_api.g_ret_sts_success (success) */
1038: /* fnd_api.g_ret_sts_error (error) */
1039: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1040: /* x_msg_count NUMBER Number of messages in the message stack */
1041: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1034: /* should be skipped. */
1035: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1036: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1037: /* fnd_api.g_ret_sts_success (success) */
1038: /* fnd_api.g_ret_sts_error (error) */
1039: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1040: /* x_msg_count NUMBER Number of messages in the message stack */
1041: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1042: /* x_repair_task_id NUMBER Task Id of the created Task */
1035: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1036: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1037: /* fnd_api.g_ret_sts_success (success) */
1038: /* fnd_api.g_ret_sts_error (error) */
1039: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1040: /* x_msg_count NUMBER Number of messages in the message stack */
1041: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1042: /* x_repair_task_id NUMBER Task Id of the created Task */
1043: /*-----------------------------------------------------------------------------------------------------------*/
1042: /* x_repair_task_id NUMBER Task Id of the created Task */
1043: /*-----------------------------------------------------------------------------------------------------------*/
1044: procedure CREATE_REPAIR_TASK
1045: ( p_api_version IN NUMBER,
1046: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1047: p_commit IN VARCHAR2 := fnd_api.g_false,
1048: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1049: p_create_repair_task_rec IN REPAIR_TASK_REC,
1050: x_return_status OUT NOCOPY VARCHAR2,
1043: /*-----------------------------------------------------------------------------------------------------------*/
1044: procedure CREATE_REPAIR_TASK
1045: ( p_api_version IN NUMBER,
1046: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1047: p_commit IN VARCHAR2 := fnd_api.g_false,
1048: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1049: p_create_repair_task_rec IN REPAIR_TASK_REC,
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: x_msg_count OUT NOCOPY NUMBER,
1044: procedure CREATE_REPAIR_TASK
1045: ( p_api_version IN NUMBER,
1046: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1047: p_commit IN VARCHAR2 := fnd_api.g_false,
1048: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1049: p_create_repair_task_rec IN REPAIR_TASK_REC,
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: x_msg_count OUT NOCOPY NUMBER,
1052: x_msg_data OUT NOCOPY VARCHAR2,
1058: /* procedure name: update_repair_task */
1059: /* description : procedure used to update DR specifc task in Depot tables */
1060: /* Called from : Depot Repair Form to Update DR specifc Task */
1061: /* Input Parm : p_api_version NUMBER Required Api Version number */
1062: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1063: /* default value is fnd_api.g_false */
1064: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1065: /* fnd_api.g_false */
1066: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1059: /* description : procedure used to update DR specifc task in Depot tables */
1060: /* Called from : Depot Repair Form to Update DR specifc Task */
1061: /* Input Parm : p_api_version NUMBER Required Api Version number */
1062: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1063: /* default value is fnd_api.g_false */
1064: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1065: /* fnd_api.g_false */
1066: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1067: /* validation steps must be done and which steps */
1060: /* Called from : Depot Repair Form to Update DR specifc Task */
1061: /* Input Parm : p_api_version NUMBER Required Api Version number */
1062: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1063: /* default value is fnd_api.g_false */
1064: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1065: /* fnd_api.g_false */
1066: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1067: /* validation steps must be done and which steps */
1068: /* should be skipped. */
1061: /* Input Parm : p_api_version NUMBER Required Api Version number */
1062: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1063: /* default value is fnd_api.g_false */
1064: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1065: /* fnd_api.g_false */
1066: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1067: /* validation steps must be done and which steps */
1068: /* should be skipped. */
1069: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1067: /* validation steps must be done and which steps */
1068: /* should be skipped. */
1069: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1070: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1071: /* fnd_api.g_ret_sts_success (success) */
1072: /* fnd_api.g_ret_sts_error (error) */
1073: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1074: /* x_msg_count NUMBER Number of messages in the message stack */
1075: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1068: /* should be skipped. */
1069: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1070: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1071: /* fnd_api.g_ret_sts_success (success) */
1072: /* fnd_api.g_ret_sts_error (error) */
1073: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1074: /* x_msg_count NUMBER Number of messages in the message stack */
1075: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1076: /*-----------------------------------------------------------------------------------------------------------*/
1069: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1070: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1071: /* fnd_api.g_ret_sts_success (success) */
1072: /* fnd_api.g_ret_sts_error (error) */
1073: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1074: /* x_msg_count NUMBER Number of messages in the message stack */
1075: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1076: /*-----------------------------------------------------------------------------------------------------------*/
1077:
1076: /*-----------------------------------------------------------------------------------------------------------*/
1077:
1078: procedure UPDATE_REPAIR_TASK
1079: ( p_api_version IN NUMBER,
1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_commit IN VARCHAR2 := fnd_api.g_false,
1082: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1083: p_update_repair_task_rec IN REPAIR_TASK_REC,
1084: x_return_status OUT NOCOPY VARCHAR2,
1077:
1078: procedure UPDATE_REPAIR_TASK
1079: ( p_api_version IN NUMBER,
1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_commit IN VARCHAR2 := fnd_api.g_false,
1082: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1083: p_update_repair_task_rec IN REPAIR_TASK_REC,
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1078: procedure UPDATE_REPAIR_TASK
1079: ( p_api_version IN NUMBER,
1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_commit IN VARCHAR2 := fnd_api.g_false,
1082: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1083: p_update_repair_task_rec IN REPAIR_TASK_REC,
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_count OUT NOCOPY NUMBER,
1086: x_msg_data OUT NOCOPY VARCHAR2