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

APPS.CSD_PROCESS_PVT dependencies on FND_API

Line 43: INCIDENT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 44: PARTY_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,

Line 45: ACCOUNT_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,

Line 46: ORG_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,

Line 47: ORDER_HEADER_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 48: ORDER_LINE_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,
52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 49: PICKING_RULE_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,
53: SHIPPED_QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 50: PICK_FROM_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

Line 51: DEF_STAGING_SUBINVENTORY VARCHAR2(30) := FND_API.G_MISS_CHAR,

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: );

Line 52: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

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:

Line 53: SHIPPED_QUANTITY 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:
57:

Line 54: LOCATOR_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:
58: /*--------------------------------------------------*/

Line 66: request_date DATE := FND_API.G_MISS_DATE,

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,

Line 67: type_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 68: type_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 69: status_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 70: status_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 71: severity_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 72: severity_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 73: urgency_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,

Line 74: urgency_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 75: closed_date DATE := FND_API.G_MISS_DATE,

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,

Line 76: owner_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,
80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 77: owner_group_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 78: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

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,

Line 79: summary VARCHAR2(240):= 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,

Line 80: caller_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 81: customer_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,
85: verify_cp_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 82: customer_number VARCHAR2(30) := 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,

Line 83: employee_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,

Line 84: employee_number VARCHAR2(30) := 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,
88: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

Line 85: verify_cp_flag VARCHAR2(1) := 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,
89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,

Line 86: customer_product_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,

Line 87: cp_ref_number NUMBER := FND_API.G_MISS_NUM,

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,

Line 88: inventory_item_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,
92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 89: inventory_org_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 90: current_serial_number VARCHAR2(30) := 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,

Line 91: original_order_number 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,
95: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

Line 92: purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 93: problem_code VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 94: exp_resolution_date DATE := FND_API.G_MISS_DATE,

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,

Line 95: bill_to_site_use_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,

Line 96: ship_to_site_use_id 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,
100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 97: contract_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 98: account_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,

Line 99: resource_type VARCHAR2(30) := 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,

Line 100: cust_po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 101: cp_revision_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,

Line 102: inv_item_revision VARCHAR2(3) := FND_API.G_MISS_CHAR,

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,

Line 103: sr_contact_point_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,
107: primary_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 104: party_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 105: contact_point_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 106: contact_point_type VARCHAR2(30) := 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

Line 107: primary_flag VARCHAR2(1) := 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
111: /*Fixed for bug#5589395 below column added for DFF on SR*/

Line 108: contact_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 109: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 155: product_transaction_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 156: repair_line_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 157: estimate_detail_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,

Line 158: action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 159: action_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 160: incident_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,

Line 161: transaction_type_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,

Line 162: business_process_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,

Line 163: txn_billing_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,

Line 164: original_source_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 165: source_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,
169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 166: line_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,
170: line_category_code VARCHAR2(6) := FND_API.G_MISS_CHAR,

Line 167: order_number VARCHAR2(30) := 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,

Line 168: status VARCHAR2(30) := 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,

Line 169: currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

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,

Line 170: line_category_code VARCHAR2(6) := 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,

Line 171: unit_of_measure_code VARCHAR2(3) := FND_API.G_MISS_CHAR,

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

Line 172: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 173: revision VARCHAR2(10) := 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

Line 174: quantity NUMBER := FND_API.G_MISS_NUM,

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,

Line 176: -- serial_number VARCHAR2(50) := 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

Line 178: -- shipped_serial_number VARCHAR2(30) := 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
181: -- instance_id NUMBER := FND_API.G_MISS_NUM,
182: -- (commented instance number) as it is replaced by Source_instance_number 11.5.10

Line 179: lot_number VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226

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,

Line 181: -- instance_id 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,

Line 183: -- instance_number 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,

Line 184: price_list_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,

Line 185: contract_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,

Line 186: coverage_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,

Line 187: coverage_txn_group_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,

Line 188: coverage_bill_rate_id 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,
192: organization_id NUMBER := FND_API.G_MISS_NUM,

Line 189: order_header_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,

Line 190: order_line_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,

Line 191: sub_inventory VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 192: organization_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,
196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,

Line 193: invoice_to_org_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,
197: add_to_order_flag VARCHAR2(1) := 'F',

Line 194: ship_to_org_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',
198: new_order_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 195: no_charge_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,

Line 196: after_warranty_cost NUMBER := FND_API.G_MISS_NUM,

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,

Line 198: new_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,

Line 199: interface_to_om_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,

Line 200: book_sales_order_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,
204: prod_txn_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 201: release_sales_order_flag VARCHAR2(1) := 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,

Line 202: ship_sales_order_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,

Line 203: prod_txn_status 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,

Line 204: prod_txn_code VARCHAR2(30) := 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,
208: last_update_date DATE := FND_API.G_MISS_DATE,

Line 205: process_txn_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,
209: creation_date DATE := FND_API.G_MISS_DATE,

Line 206: return_reason VARCHAR2(30) := 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,
210: last_updated_by NUMBER := FND_API.G_MISS_NUM,

Line 207: return_by_date DATE := FND_API.G_MISS_DATE,

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,

Line 208: last_update_date DATE := FND_API.G_MISS_DATE,

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,

Line 209: creation_date DATE := FND_API.G_MISS_DATE,

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,

Line 210: last_updated_by NUMBER := FND_API.G_MISS_NUM,

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,

Line 211: created_by NUMBER := FND_API.G_MISS_NUM,

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,

Line 212: last_update_login NUMBER := FND_API.G_MISS_NUM,

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,

Line 213: attribute1 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,

Line 214: attribute2 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,

Line 215: attribute3 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,

Line 216: attribute4 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,

Line 217: attribute5 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,

Line 218: attribute6 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,

Line 219: attribute7 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,

Line 220: attribute8 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,

Line 221: attribute9 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,

Line 222: attribute10 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,

Line 223: attribute11 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,

Line 224: attribute12 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,

Line 225: attribute13 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,
229: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 226: attribute14 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,
230: security_group_id NUMBER := FND_API.G_MISS_NUM,

Line 227: attribute15 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,
231: po_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 228: context VARCHAR2(30) := 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

Line 229: object_version_number NUMBER := FND_API.G_MISS_NUM,

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

Line 230: security_group_id NUMBER := FND_API.G_MISS_NUM,

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)

Line 231: po_number VARCHAR2(50) := 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)
235: non_source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 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

Line 237: non_source_instance_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 238: source_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

Line 241: source_instance_id NUMBER := FND_API.G_MISS_NUM,

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.

Line 243: req_header_id NUMBER := FND_API.G_MISS_NUM,

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.

Line 244: req_line_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 246: prd_txn_qty_received 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,

Line 248: prd_txn_qty_shipped 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,
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

Line 250: sub_inventory_rcvd VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 252: lot_number_rcvd VARCHAR2(80) := FND_API.G_MISS_CHAR, -- fix for bug#4625226

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

Line 254: locator_id NUMBER := FND_API.G_MISS_NUM,

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

Line 255: charge_line_type 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
259: picking_rule_id NUMBER,

Line 257: add_to_order_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 267: project_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 268: task_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,

Line 269: unit_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 271: bill_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

Line 272: bill_to_account_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
276: internal_po_header_id NUMBER := FND_API.G_MISS_NUM

Line 273: ship_to_party_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: );

Line 274: ship_to_account_id NUMBER := FND_API.G_MISS_NUM,

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:

Line 276: internal_po_header_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:
279: TYPE PRODUCT_TXN_TBL IS TABLE OF PRODUCT_TXN_REC INDEX BY BINARY_INTEGER;
280:

Line 309: TASK_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 310: TASK_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,

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,

Line 311: TASK_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 312: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR,

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,

Line 313: TASK_STATUS_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 314: TASK_PRIORITY_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 315: TASK_PRIORITY_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,

Line 316: OWNER_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

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,

Line 317: OWNER_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,

Line 318: OWNER_TERRITORY_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,

Line 319: ASSIGNED_BY_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,

Line 320: CUSTOMER_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,
324: PLANNED_END_DATE DATE := FND_API.G_MISS_DATE,

Line 321: CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 322: ADDRESS_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,
326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,

Line 323: PLANNED_START_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,

Line 324: PLANNED_END_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,

Line 325: SCHEDULED_START_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,

Line 326: SCHEDULED_END_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 327: ACTUAL_START_DATE DATE := FND_API.G_MISS_DATE,

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,

Line 328: ACTUAL_END_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,
332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 329: TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 330: SOURCE_OBJECT_TYPE_CODE VARCHAR2(60) := FND_API.G_MISS_CHAR,

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,

Line 331: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

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,

Line 332: SOURCE_OBJECT_NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,

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,

Line 333: DURATION NUMBER := FND_API.G_MISS_NUM,

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,

Line 334: DURATION_UOM VARCHAR2(3) := FND_API.G_MISS_CHAR,

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,

Line 335: PLANNED_EFFORT NUMBER := FND_API.G_MISS_NUM,

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,

Line 336: PLANNED_EFFORT_UOM VARCHAR2(3) := 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,

Line 337: ACTUAL_EFFORT NUMBER := FND_API.G_MISS_NUM,

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,

Line 338: ACTUAL_EFFORT_UOM VARCHAR2(3) := 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,

Line 339: PRIVATE_FLAG VARCHAR2(1) := 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,

Line 340: PUBLISH_FLAG VARCHAR2(1) := 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,

Line 341: RESTRICT_CLOSURE_FLAG VARCHAR2(1) := 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,

Line 342: ATTRIBUTE1 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,

Line 343: ATTRIBUTE2 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,

Line 344: ATTRIBUTE3 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,

Line 345: ATTRIBUTE4 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,

Line 346: ATTRIBUTE5 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,

Line 347: ATTRIBUTE6 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,

Line 348: ATTRIBUTE7 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,

Line 349: ATTRIBUTE8 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,

Line 350: ATTRIBUTE9 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,

Line 351: ATTRIBUTE10 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,

Line 352: ATTRIBUTE11 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,

Line 353: ATTRIBUTE12 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,

Line 354: ATTRIBUTE13 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,

Line 355: ATTRIBUTE14 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,
359: SOFT_BOUND_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 356: ATTRIBUTE15 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,
360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,

Line 357: ATTRIBUTE_CATEGORY 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,
361: ESCALATION_LEVEL VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 358: BOUND_MODE_CODE 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

Line 359: SOFT_BOUND_FLAG VARCHAR2(1) := 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
363: );

Line 360: PARENT_TASK_ID NUMBER := FND_API.G_MISS_NUM,

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:

Line 361: ESCALATION_LEVEL VARCHAR2(30) := 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:
365: /*---------------------------------------------------*/

Line 362: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

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 / */

Line 380: location_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 381: address1 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,

Line 382: address2 VARCHAR2(240) := 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,

Line 383: address3 VARCHAR2(240) := 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,

Line 384: address4 VARCHAR2(240) := 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,

Line 385: city 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,

Line 386: state 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,

Line 387: postal_code 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,

Line 388: province VARCHAR2(60) := 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,

Line 389: county VARCHAR2(60) := 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,

Line 390: country 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,
394: postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 391: language VARCHAR2(4) := 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,

Line 392: position 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,

Line 393: address_key VARCHAR2(500) := 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,

Line 394: postal_plus4_code VARCHAR2(10) := 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,

Line 395: delivery_point_code VARCHAR2(50) := 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,

Line 396: location_directions VARCHAR2(640) := 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,

Line 397: -- address_error_code 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,
401: sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 398: clli_code VARCHAR2(60) := 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,

Line 399: short_description VARCHAR2(240) := 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,

Line 400: description VARCHAR2(2000) := 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,
404: address_expiration_date DATE := FND_API.G_MISS_DATE,

Line 401: sales_tax_geocode VARCHAR2(30) := 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,
405: address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 402: sales_tax_inside_city_limits 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 */

Line 403: address_effective_date DATE := FND_API.G_MISS_DATE,

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,

Line 404: address_expiration_date DATE := FND_API.G_MISS_DATE,

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,

Line 405: address_style VARCHAR2(30) := 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,

Line 407: po_box_number 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,

Line 408: house_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,

Line 409: street_suffix 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,

Line 410: street 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

Line 411: street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

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,

Line 412: floor 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,

Line 413: suite 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,
417: secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 415: apartment_number 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,
418: rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
419: rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 416: apartment_flag VARCHAR2(1) := 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,

Line 417: secondary_suffix_element VARCHAR2(240) := 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,

Line 418: rural_route_type 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,

Line 419: rural_route_number 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,

Line 420: building 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,

Line 421: room VARCHAR2(50) := 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,

Line 422: time_zone VARCHAR2(50) := 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,

Line 423: post_office 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,
427: wh_update_date DATE := FND_API.G_MISS_DATE

Line 424: dodaac VARCHAR2(6) := 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
428: */

Line 425: trailing_directory_code VARCHAR2(60) := 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: */
429: /* swai: new TCA v2 fields */

Line 426: life_cycle_status VARCHAR2(30) := 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 */
430: timezone_id NUMBER := FND_API.G_MISS_NUM,

Line 427: wh_update_date DATE := FND_API.G_MISS_DATE

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',

Line 430: timezone_id NUMBER := FND_API.G_MISS_NUM,

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: );

Line 433: actual_content_source VARCHAR2(30) := FND_API.G_MISS_CHAR

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: /*---------------------------------------------------*/

Line 474: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 475: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 476: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 ,

Line 496: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 497: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 518: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 519: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 520: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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,

Line 537: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 538: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 539: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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);

Line 554: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 555: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 556: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );

Line 572: p_commit IN VARCHAR2 := fnd_api.g_false,

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

Line 573: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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

Line 574: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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: */

Line 594: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 595: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 596: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );

Line 629: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 630: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 631: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );

Line 647: p_commit IN VARCHAR2 := fnd_api.g_false,

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,

Line 648: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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,

Line 649: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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 );

Line 664: p_commit IN VARCHAR2 := fnd_api.g_false,

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: p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,

Line 665: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

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: p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
669: p_return_reason_code IN VARCHAR2 := NULL,

Line 666: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

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: p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
669: p_return_reason_code IN VARCHAR2 := NULL,
670: p_invoice_to_org_id IN NUMBER := NULL,

Line 668: p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,

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: p_create_thirdpty_line IN VARCHAR2 := fnd_api.g_false,
669: p_return_reason_code IN VARCHAR2 := NULL,
670: p_invoice_to_org_id IN NUMBER := NULL,
671: p_ship_to_org_id IN NUMBER := NULL,
672: x_return_status OUT NOCOPY VARCHAR2,

Line 684: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

680: /* procedure name: create_task */
681: /* description : procedure used to create task */
682: /* Called from : Depot Repair Form to Create Task */
683: /* Input Parm : p_api_version NUMBER Required Api Version number */
684: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
685: /* default value is fnd_api.g_false */
686: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
687: /* fnd_api.g_false */
688: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 685: /* default value is fnd_api.g_false */

681: /* description : procedure used to create task */
682: /* Called from : Depot Repair Form to Create Task */
683: /* Input Parm : p_api_version NUMBER Required Api Version number */
684: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
685: /* default value is fnd_api.g_false */
686: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
687: /* fnd_api.g_false */
688: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
689: /* validation steps must be done and which steps */

Line 686: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

682: /* Called from : Depot Repair Form to Create Task */
683: /* Input Parm : p_api_version NUMBER Required Api Version number */
684: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
685: /* default value is fnd_api.g_false */
686: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
687: /* fnd_api.g_false */
688: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
689: /* validation steps must be done and which steps */
690: /* should be skipped. */

Line 687: /* fnd_api.g_false */

683: /* Input Parm : p_api_version NUMBER Required Api Version number */
684: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
685: /* default value is fnd_api.g_false */
686: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
687: /* fnd_api.g_false */
688: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
689: /* validation steps must be done and which steps */
690: /* should be skipped. */
691: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */

Line 693: /* fnd_api.g_ret_sts_success (success) */

689: /* validation steps must be done and which steps */
690: /* should be skipped. */
691: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
692: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
693: /* fnd_api.g_ret_sts_success (success) */
694: /* fnd_api.g_ret_sts_error (error) */
695: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
696: /* x_msg_count NUMBER Number of messages in the message stack */
697: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 694: /* fnd_api.g_ret_sts_error (error) */

690: /* should be skipped. */
691: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
692: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
693: /* fnd_api.g_ret_sts_success (success) */
694: /* fnd_api.g_ret_sts_error (error) */
695: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
696: /* x_msg_count NUMBER Number of messages in the message stack */
697: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
698: /* x_task_id NUMBER Task Id of the created Task */

Line 695: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

691: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
692: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
693: /* fnd_api.g_ret_sts_success (success) */
694: /* fnd_api.g_ret_sts_error (error) */
695: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
696: /* x_msg_count NUMBER Number of messages in the message stack */
697: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
698: /* x_task_id NUMBER Task Id of the created Task */
699: /*-----------------------------------------------------------------------------------------------------------*/

Line 702: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

698: /* x_task_id NUMBER Task Id of the created Task */
699: /*-----------------------------------------------------------------------------------------------------------*/
700: procedure CREATE_TASK
701: ( p_api_version IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
703: p_commit IN VARCHAR2 := fnd_api.g_false,
704: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
705: p_create_task_rec IN CREATE_TASK_REC_TYPE,
706: x_return_status OUT NOCOPY VARCHAR2,

Line 703: p_commit IN VARCHAR2 := fnd_api.g_false,

699: /*-----------------------------------------------------------------------------------------------------------*/
700: procedure CREATE_TASK
701: ( p_api_version IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
703: p_commit IN VARCHAR2 := fnd_api.g_false,
704: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
705: p_create_task_rec IN CREATE_TASK_REC_TYPE,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,

Line 704: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

700: procedure CREATE_TASK
701: ( p_api_version IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
703: p_commit IN VARCHAR2 := fnd_api.g_false,
704: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
705: p_create_task_rec IN CREATE_TASK_REC_TYPE,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,
708: x_msg_data OUT NOCOPY VARCHAR2,

Line 717: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

713: /* procedure name: update_task */
714: /* description : procedure used to update task */
715: /* Called from : Depot Repair Form to Create Task */
716: /* Input Parm : p_api_version NUMBER Required Api Version number */
717: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
718: /* default value is fnd_api.g_false */
719: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
720: /* fnd_api.g_false */
721: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 718: /* default value is fnd_api.g_false */

714: /* description : procedure used to update task */
715: /* Called from : Depot Repair Form to Create Task */
716: /* Input Parm : p_api_version NUMBER Required Api Version number */
717: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
718: /* default value is fnd_api.g_false */
719: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
720: /* fnd_api.g_false */
721: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
722: /* validation steps must be done and which steps */

Line 719: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

715: /* Called from : Depot Repair Form to Create Task */
716: /* Input Parm : p_api_version NUMBER Required Api Version number */
717: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
718: /* default value is fnd_api.g_false */
719: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
720: /* fnd_api.g_false */
721: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
722: /* validation steps must be done and which steps */
723: /* should be skipped. */

Line 720: /* fnd_api.g_false */

716: /* Input Parm : p_api_version NUMBER Required Api Version number */
717: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
718: /* default value is fnd_api.g_false */
719: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
720: /* fnd_api.g_false */
721: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
722: /* validation steps must be done and which steps */
723: /* should be skipped. */
724: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */

Line 726: /* fnd_api.g_ret_sts_success (success) */

722: /* validation steps must be done and which steps */
723: /* should be skipped. */
724: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
725: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
726: /* fnd_api.g_ret_sts_success (success) */
727: /* fnd_api.g_ret_sts_error (error) */
728: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
729: /* x_msg_count NUMBER Number of messages in the message stack */
730: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 727: /* fnd_api.g_ret_sts_error (error) */

723: /* should be skipped. */
724: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
725: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
726: /* fnd_api.g_ret_sts_success (success) */
727: /* fnd_api.g_ret_sts_error (error) */
728: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
729: /* x_msg_count NUMBER Number of messages in the message stack */
730: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
731: /*-----------------------------------------------------------------------------------------------------------*/

Line 728: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

724: /* CREATE_TASK_REC_TYPE RECORD Required Columns are in the Record CREATE_TASK_REC_TYPE */
725: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
726: /* fnd_api.g_ret_sts_success (success) */
727: /* fnd_api.g_ret_sts_error (error) */
728: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
729: /* x_msg_count NUMBER Number of messages in the message stack */
730: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
731: /*-----------------------------------------------------------------------------------------------------------*/
732:

Line 735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

731: /*-----------------------------------------------------------------------------------------------------------*/
732:
733: procedure UPDATE_TASK
734: ( p_api_version IN NUMBER,
735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
736: p_commit IN VARCHAR2 := fnd_api.g_false,
737: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
738: p_create_task_rec IN CREATE_TASK_REC_TYPE,
739: x_return_status OUT NOCOPY VARCHAR2,

Line 736: p_commit IN VARCHAR2 := fnd_api.g_false,

732:
733: procedure UPDATE_TASK
734: ( p_api_version IN NUMBER,
735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
736: p_commit IN VARCHAR2 := fnd_api.g_false,
737: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
738: p_create_task_rec IN CREATE_TASK_REC_TYPE,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,

Line 737: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

733: procedure UPDATE_TASK
734: ( p_api_version IN NUMBER,
735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
736: p_commit IN VARCHAR2 := fnd_api.g_false,
737: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
738: p_create_task_rec IN CREATE_TASK_REC_TYPE,
739: x_return_status OUT NOCOPY VARCHAR2,
740: x_msg_count OUT NOCOPY NUMBER,
741: x_msg_data OUT NOCOPY VARCHAR2

Line 751: /* fnd_api.g_ret_sts_success (success) */

747: /* description : procedure to create Address for the Contact */
748: /* Called from : Depot Repair Form to Create Address */
749: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
750: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
751: /* fnd_api.g_ret_sts_success (success) */
752: /* fnd_api.g_ret_sts_error (error) */
753: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
754: /* x_msg_count NUMBER Number of messages in the message stack */
755: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 752: /* fnd_api.g_ret_sts_error (error) */

748: /* Called from : Depot Repair Form to Create Address */
749: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
750: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
751: /* fnd_api.g_ret_sts_success (success) */
752: /* fnd_api.g_ret_sts_error (error) */
753: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
754: /* x_msg_count NUMBER Number of messages in the message stack */
755: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
756: /* x_location_id NUMBER Location ID of the Contacts address created */

Line 753: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

749: /* Input Parm : p_address_rec RECORD Required Record ADDRESS_REC_TYPE */
750: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
751: /* fnd_api.g_ret_sts_success (success) */
752: /* fnd_api.g_ret_sts_error (error) */
753: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
754: /* x_msg_count NUMBER Number of messages in the message stack */
755: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
756: /* x_location_id NUMBER Location ID of the Contacts address created */
757: /*-----------------------------------------------------------------------------------------------------------*/

Line 773: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

769: /* description : procedure used to create Repair Order history */
770: /* for task creation */
771: /* Called from : Depot Repair Form to Create Address */
772: /* Input Parm : p_api_version NUMBER Required Api Version number */
773: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
774: /* default value is fnd_api.g_false */
775: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
776: /* fnd_api.g_false */
777: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 774: /* default value is fnd_api.g_false */

770: /* for task creation */
771: /* Called from : Depot Repair Form to Create Address */
772: /* Input Parm : p_api_version NUMBER Required Api Version number */
773: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
774: /* default value is fnd_api.g_false */
775: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
776: /* fnd_api.g_false */
777: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
778: /* validation steps must be done and which steps */

Line 775: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

771: /* Called from : Depot Repair Form to Create Address */
772: /* Input Parm : p_api_version NUMBER Required Api Version number */
773: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
774: /* default value is fnd_api.g_false */
775: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
776: /* fnd_api.g_false */
777: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
778: /* validation steps must be done and which steps */
779: /* should be skipped. */

Line 776: /* fnd_api.g_false */

772: /* Input Parm : p_api_version NUMBER Required Api Version number */
773: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
774: /* default value is fnd_api.g_false */
775: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
776: /* fnd_api.g_false */
777: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
778: /* validation steps must be done and which steps */
779: /* should be skipped. */
780: /* p_task_id NUMBER Required Task Id */

Line 783: /* fnd_api.g_ret_sts_success (success) */

779: /* should be skipped. */
780: /* p_task_id NUMBER Required Task Id */
781: /* p_repair_line_id NUMBER Required Repair_line_id */
782: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
783: /* fnd_api.g_ret_sts_success (success) */
784: /* fnd_api.g_ret_sts_error (error) */
785: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
786: /* x_msg_count NUMBER Number of messages in the message stack */
787: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 784: /* fnd_api.g_ret_sts_error (error) */

780: /* p_task_id NUMBER Required Task Id */
781: /* p_repair_line_id NUMBER Required Repair_line_id */
782: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
783: /* fnd_api.g_ret_sts_success (success) */
784: /* fnd_api.g_ret_sts_error (error) */
785: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
786: /* x_msg_count NUMBER Number of messages in the message stack */
787: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
788: /*-----------------------------------------------------------------------------------------------------------*/

Line 785: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

781: /* p_repair_line_id NUMBER Required Repair_line_id */
782: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
783: /* fnd_api.g_ret_sts_success (success) */
784: /* fnd_api.g_ret_sts_error (error) */
785: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
786: /* x_msg_count NUMBER Number of messages in the message stack */
787: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
788: /*-----------------------------------------------------------------------------------------------------------*/
789:

Line 792: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

788: /*-----------------------------------------------------------------------------------------------------------*/
789:
790: PROCEDURE Create_repair_task_hist
791: ( p_api_version IN NUMBER,
792: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
793: p_commit IN VARCHAR2 := fnd_api.g_false,
794: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
795: p_task_id IN NUMBER,
796: p_repair_line_id IN NUMBER,

Line 793: p_commit IN VARCHAR2 := fnd_api.g_false,

789:
790: PROCEDURE Create_repair_task_hist
791: ( p_api_version IN NUMBER,
792: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
793: p_commit IN VARCHAR2 := fnd_api.g_false,
794: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
795: p_task_id IN NUMBER,
796: p_repair_line_id IN NUMBER,
797: x_return_status OUT NOCOPY VARCHAR2,

Line 794: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

790: PROCEDURE Create_repair_task_hist
791: ( p_api_version IN NUMBER,
792: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
793: p_commit IN VARCHAR2 := fnd_api.g_false,
794: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
795: p_task_id IN NUMBER,
796: p_repair_line_id IN NUMBER,
797: x_return_status OUT NOCOPY VARCHAR2,
798: x_msg_count OUT NOCOPY NUMBER,

Line 808: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

804: /* description : procedure used to create Repair Order history */
805: /* for task creation */
806: /* Called from : Depot Repair Form to Create Address */
807: /* Input Parm : p_api_version NUMBER Required Api Version number */
808: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
809: /* default value is fnd_api.g_false */
810: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
811: /* fnd_api.g_false */
812: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 809: /* default value is fnd_api.g_false */

805: /* for task creation */
806: /* Called from : Depot Repair Form to Create Address */
807: /* Input Parm : p_api_version NUMBER Required Api Version number */
808: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
809: /* default value is fnd_api.g_false */
810: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
811: /* fnd_api.g_false */
812: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
813: /* validation steps must be done and which steps */

Line 810: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

806: /* Called from : Depot Repair Form to Create Address */
807: /* Input Parm : p_api_version NUMBER Required Api Version number */
808: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
809: /* default value is fnd_api.g_false */
810: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
811: /* fnd_api.g_false */
812: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
813: /* validation steps must be done and which steps */
814: /* should be skipped.

Line 811: /* fnd_api.g_false */

807: /* Input Parm : p_api_version NUMBER Required Api Version number */
808: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
809: /* default value is fnd_api.g_false */
810: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
811: /* fnd_api.g_false */
812: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
813: /* validation steps must be done and which steps */
814: /* should be skipped.
815: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */

Line 817: /* fnd_api.g_ret_sts_success (success) */

813: /* validation steps must be done and which steps */
814: /* should be skipped.
815: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
816: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
817: /* fnd_api.g_ret_sts_success (success) */
818: /* fnd_api.g_ret_sts_error (error) */
819: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
820: /* x_msg_count NUMBER Number of messages in the message stack */
821: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 818: /* fnd_api.g_ret_sts_error (error) */

814: /* should be skipped.
815: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
816: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
817: /* fnd_api.g_ret_sts_success (success) */
818: /* fnd_api.g_ret_sts_error (error) */
819: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
820: /* x_msg_count NUMBER Number of messages in the message stack */
821: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
822: /*-----------------------------------------------------------------------------------------------------------*/

Line 819: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

815: /* p_task_activity_rec CSD_PROCESS_PVT.TASK_ACTIVITY_REC Used for logging task activity */
816: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
817: /* fnd_api.g_ret_sts_success (success) */
818: /* fnd_api.g_ret_sts_error (error) */
819: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
820: /* x_msg_count NUMBER Number of messages in the message stack */
821: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
822: /*-----------------------------------------------------------------------------------------------------------*/
823:

Line 826: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

822: /*-----------------------------------------------------------------------------------------------------------*/
823:
824: PROCEDURE Create_repair_task_hist
825: ( p_api_version IN NUMBER,
826: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
827: p_commit IN VARCHAR2 := fnd_api.g_false,
828: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
829: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
830: x_return_status OUT NOCOPY VARCHAR2,

Line 827: p_commit IN VARCHAR2 := fnd_api.g_false,

823:
824: PROCEDURE Create_repair_task_hist
825: ( p_api_version IN NUMBER,
826: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
827: p_commit IN VARCHAR2 := fnd_api.g_false,
828: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
829: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,

Line 828: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

824: PROCEDURE Create_repair_task_hist
825: ( p_api_version IN NUMBER,
826: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
827: p_commit IN VARCHAR2 := fnd_api.g_false,
828: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
829: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
830: x_return_status OUT NOCOPY VARCHAR2,
831: x_msg_count OUT NOCOPY NUMBER,
832: x_msg_data OUT NOCOPY VARCHAR2

Line 842: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

838: /* description : procedure used to Update Repair Order history */
839: /* for task creation */
840: /* Called from : Depot Repair Form to update to Repair history */
841: /* Input Parm : p_api_version NUMBER Required Api Version number */
842: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
843: /* default value is fnd_api.g_false */
844: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
845: /* fnd_api.g_false */
846: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 843: /* default value is fnd_api.g_false */

839: /* for task creation */
840: /* Called from : Depot Repair Form to update to Repair history */
841: /* Input Parm : p_api_version NUMBER Required Api Version number */
842: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
843: /* default value is fnd_api.g_false */
844: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
845: /* fnd_api.g_false */
846: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
847: /* validation steps must be done and which steps */

Line 844: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

840: /* Called from : Depot Repair Form to update to Repair history */
841: /* Input Parm : p_api_version NUMBER Required Api Version number */
842: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
843: /* default value is fnd_api.g_false */
844: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
845: /* fnd_api.g_false */
846: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
847: /* validation steps must be done and which steps */
848: /* should be skipped. */

Line 845: /* fnd_api.g_false */

841: /* Input Parm : p_api_version NUMBER Required Api Version number */
842: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
843: /* default value is fnd_api.g_false */
844: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
845: /* fnd_api.g_false */
846: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
847: /* validation steps must be done and which steps */
848: /* should be skipped. */
849: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */

Line 851: /* fnd_api.g_ret_sts_success (success) */

847: /* validation steps must be done and which steps */
848: /* should be skipped. */
849: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
850: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
851: /* fnd_api.g_ret_sts_success (success) */
852: /* fnd_api.g_ret_sts_error (error) */
853: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
854: /* x_msg_count NUMBER Number of messages in the message stack */
855: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 852: /* fnd_api.g_ret_sts_error (error) */

848: /* should be skipped. */
849: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
850: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
851: /* fnd_api.g_ret_sts_success (success) */
852: /* fnd_api.g_ret_sts_error (error) */
853: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
854: /* x_msg_count NUMBER Number of messages in the message stack */
855: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
856: /*-----------------------------------------------------------------------------------------------------------*/

Line 853: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

849: /* p_task_acticity_rec TASK_ACTIVITY_REC Required Used to log activity */
850: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
851: /* fnd_api.g_ret_sts_success (success) */
852: /* fnd_api.g_ret_sts_error (error) */
853: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
854: /* x_msg_count NUMBER Number of messages in the message stack */
855: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
856: /*-----------------------------------------------------------------------------------------------------------*/
857:

Line 861: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

857:
858: /*
859: PROCEDURE Update_repair_task_hist
860: ( p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
862: p_commit IN VARCHAR2 := fnd_api.g_false,
863: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
864: p_task_id IN NUMBER,
865: p_repair_line_id IN NUMBER,

Line 862: p_commit IN VARCHAR2 := fnd_api.g_false,

858: /*
859: PROCEDURE Update_repair_task_hist
860: ( p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
862: p_commit IN VARCHAR2 := fnd_api.g_false,
863: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
864: p_task_id IN NUMBER,
865: p_repair_line_id IN NUMBER,
866: x_return_status OUT NOCOPY VARCHAR2,

Line 863: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

859: PROCEDURE Update_repair_task_hist
860: ( p_api_version IN NUMBER,
861: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
862: p_commit IN VARCHAR2 := fnd_api.g_false,
863: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
864: p_task_id IN NUMBER,
865: p_repair_line_id IN NUMBER,
866: x_return_status OUT NOCOPY VARCHAR2,
867: x_msg_count OUT NOCOPY NUMBER,

Line 877: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

873: /* description : procedure used to Update Repair Order history */
874: /* for task creation */
875: /* Called from : Depot Repair Form to update to Repair history */
876: /* Input Parm : p_api_version NUMBER Required Api Version number */
877: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
878: /* default value is fnd_api.g_false */
879: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
880: /* fnd_api.g_false */
881: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 878: /* default value is fnd_api.g_false */

874: /* for task creation */
875: /* Called from : Depot Repair Form to update to Repair history */
876: /* Input Parm : p_api_version NUMBER Required Api Version number */
877: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
878: /* default value is fnd_api.g_false */
879: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
880: /* fnd_api.g_false */
881: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
882: /* validation steps must be done and which steps */

Line 879: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

875: /* Called from : Depot Repair Form to update to Repair history */
876: /* Input Parm : p_api_version NUMBER Required Api Version number */
877: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
878: /* default value is fnd_api.g_false */
879: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
880: /* fnd_api.g_false */
881: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
882: /* validation steps must be done and which steps */
883: /* should be skipped. */

Line 880: /* fnd_api.g_false */

876: /* Input Parm : p_api_version NUMBER Required Api Version number */
877: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
878: /* default value is fnd_api.g_false */
879: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
880: /* fnd_api.g_false */
881: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
882: /* validation steps must be done and which steps */
883: /* should be skipped. */
884: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/

Line 886: /* fnd_api.g_ret_sts_success (success) */

882: /* validation steps must be done and which steps */
883: /* should be skipped. */
884: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
885: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
886: /* fnd_api.g_ret_sts_success (success) */
887: /* fnd_api.g_ret_sts_error (error) */
888: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
889: /* x_msg_count NUMBER Number of messages in the message stack */
890: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 887: /* fnd_api.g_ret_sts_error (error) */

883: /* should be skipped. */
884: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
885: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
886: /* fnd_api.g_ret_sts_success (success) */
887: /* fnd_api.g_ret_sts_error (error) */
888: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
889: /* x_msg_count NUMBER Number of messages in the message stack */
890: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
891: /*-----------------------------------------------------------------------------------------------------------*/

Line 888: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

884: /* p_activity_rec TASK_ACTIVITY_REC Required Task activity record*/
885: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
886: /* fnd_api.g_ret_sts_success (success) */
887: /* fnd_api.g_ret_sts_error (error) */
888: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
889: /* x_msg_count NUMBER Number of messages in the message stack */
890: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
891: /*-----------------------------------------------------------------------------------------------------------*/
892:

Line 895: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

891: /*-----------------------------------------------------------------------------------------------------------*/
892:
893: PROCEDURE Update_repair_task_hist
894: ( p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
896: p_commit IN VARCHAR2 := fnd_api.g_false,
897: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
898: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
899: x_return_status OUT NOCOPY VARCHAR2,

Line 896: p_commit IN VARCHAR2 := fnd_api.g_false,

892:
893: PROCEDURE Update_repair_task_hist
894: ( p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
896: p_commit IN VARCHAR2 := fnd_api.g_false,
897: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
898: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
899: x_return_status OUT NOCOPY VARCHAR2,
900: x_msg_count OUT NOCOPY NUMBER,

Line 897: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

893: PROCEDURE Update_repair_task_hist
894: ( p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
896: p_commit IN VARCHAR2 := fnd_api.g_false,
897: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
898: p_task_activity_rec IN CSD_PROCESS_PVT.TASK_ACTIVITY_REC,
899: x_return_status OUT NOCOPY VARCHAR2,
900: x_msg_count OUT NOCOPY NUMBER,
901: x_msg_data OUT NOCOPY VARCHAR2

Line 912: p_commit IN VARCHAR2 := fnd_api.g_false,

908: /*----------------------------------------------------------------*/
909:
910: PROCEDURE Close_status
911: ( p_api_version IN NUMBER,
912: p_commit IN VARCHAR2 := fnd_api.g_false,
913: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
914: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
915: p_incident_id IN NUMBER,
916: p_repair_line_id IN NUMBER,

Line 913: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

909:
910: PROCEDURE Close_status
911: ( p_api_version IN NUMBER,
912: p_commit IN VARCHAR2 := fnd_api.g_false,
913: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
914: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
915: p_incident_id IN NUMBER,
916: p_repair_line_id IN NUMBER,
917: x_return_status OUT NOCOPY VARCHAR2,

Line 914: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

910: PROCEDURE Close_status
911: ( p_api_version IN NUMBER,
912: p_commit IN VARCHAR2 := fnd_api.g_false,
913: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
914: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
915: p_incident_id IN NUMBER,
916: p_repair_line_id IN NUMBER,
917: x_return_status OUT NOCOPY VARCHAR2,
918: x_msg_count OUT NOCOPY NUMBER,

Line 929: p_commit IN VARCHAR2 := fnd_api.g_false,

925: /* RMA/SO lines for the given service request */
926: /*---------------------------------------------------------------*/
927: PROCEDURE Check_Service_Request
928: ( p_api_version IN NUMBER,
929: p_commit IN VARCHAR2 := fnd_api.g_false,
930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
931: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
932: p_incident_id IN NUMBER,
933: x_link_mode OUT NOCOPY NUMBER,

Line 930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

926: /*---------------------------------------------------------------*/
927: PROCEDURE Check_Service_Request
928: ( p_api_version IN NUMBER,
929: p_commit IN VARCHAR2 := fnd_api.g_false,
930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
931: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
932: p_incident_id IN NUMBER,
933: x_link_mode OUT NOCOPY NUMBER,
934: x_return_status OUT NOCOPY VARCHAR2,

Line 931: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

927: PROCEDURE Check_Service_Request
928: ( p_api_version IN NUMBER,
929: p_commit IN VARCHAR2 := fnd_api.g_false,
930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
931: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
932: p_incident_id IN NUMBER,
933: x_link_mode OUT NOCOPY NUMBER,
934: x_return_status OUT NOCOPY VARCHAR2,
935: x_msg_count OUT NOCOPY NUMBER,

Line 1032: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

1028: /* procedure name: create_repair_task */
1029: /* description : procedure used to create DR specific tasks in Depot tables */
1030: /* Called from : Depot Repair Form to Create Task */
1031: /* Input Parm : p_api_version NUMBER Required Api Version number */
1032: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1033: /* default value is fnd_api.g_false */
1034: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1035: /* fnd_api.g_false */
1036: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 1033: /* default value is fnd_api.g_false */

1029: /* description : procedure used to create DR specific tasks in Depot tables */
1030: /* Called from : Depot Repair Form to Create Task */
1031: /* Input Parm : p_api_version NUMBER Required Api Version number */
1032: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1033: /* default value is fnd_api.g_false */
1034: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1035: /* fnd_api.g_false */
1036: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1037: /* validation steps must be done and which steps */

Line 1034: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

1030: /* Called from : Depot Repair Form to Create Task */
1031: /* Input Parm : p_api_version NUMBER Required Api Version number */
1032: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1033: /* default value is fnd_api.g_false */
1034: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1035: /* fnd_api.g_false */
1036: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1037: /* validation steps must be done and which steps */
1038: /* should be skipped. */

Line 1035: /* fnd_api.g_false */

1031: /* Input Parm : p_api_version NUMBER Required Api Version number */
1032: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1033: /* default value is fnd_api.g_false */
1034: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1035: /* fnd_api.g_false */
1036: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1037: /* validation steps must be done and which steps */
1038: /* should be skipped. */
1039: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */

Line 1041: /* fnd_api.g_ret_sts_success (success) */

1037: /* validation steps must be done and which steps */
1038: /* should be skipped. */
1039: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1040: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1041: /* fnd_api.g_ret_sts_success (success) */
1042: /* fnd_api.g_ret_sts_error (error) */
1043: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1044: /* x_msg_count NUMBER Number of messages in the message stack */
1045: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 1042: /* fnd_api.g_ret_sts_error (error) */

1038: /* should be skipped. */
1039: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1040: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1041: /* fnd_api.g_ret_sts_success (success) */
1042: /* fnd_api.g_ret_sts_error (error) */
1043: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1044: /* x_msg_count NUMBER Number of messages in the message stack */
1045: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1046: /* x_repair_task_id NUMBER Task Id of the created Task */

Line 1043: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

1039: /* p_CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1040: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1041: /* fnd_api.g_ret_sts_success (success) */
1042: /* fnd_api.g_ret_sts_error (error) */
1043: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1044: /* x_msg_count NUMBER Number of messages in the message stack */
1045: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1046: /* x_repair_task_id NUMBER Task Id of the created Task */
1047: /*-----------------------------------------------------------------------------------------------------------*/

Line 1050: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1046: /* x_repair_task_id NUMBER Task Id of the created Task */
1047: /*-----------------------------------------------------------------------------------------------------------*/
1048: procedure CREATE_REPAIR_TASK
1049: ( p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1051: p_commit IN VARCHAR2 := fnd_api.g_false,
1052: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1053: p_create_repair_task_rec IN REPAIR_TASK_REC,
1054: x_return_status OUT NOCOPY VARCHAR2,

Line 1051: p_commit IN VARCHAR2 := fnd_api.g_false,

1047: /*-----------------------------------------------------------------------------------------------------------*/
1048: procedure CREATE_REPAIR_TASK
1049: ( p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1051: p_commit IN VARCHAR2 := fnd_api.g_false,
1052: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1053: p_create_repair_task_rec IN REPAIR_TASK_REC,
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: x_msg_count OUT NOCOPY NUMBER,

Line 1052: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1048: procedure CREATE_REPAIR_TASK
1049: ( p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1051: p_commit IN VARCHAR2 := fnd_api.g_false,
1052: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1053: p_create_repair_task_rec IN REPAIR_TASK_REC,
1054: x_return_status OUT NOCOPY VARCHAR2,
1055: x_msg_count OUT NOCOPY NUMBER,
1056: x_msg_data OUT NOCOPY VARCHAR2,

Line 1066: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

1062: /* procedure name: update_repair_task */
1063: /* description : procedure used to update DR specifc task in Depot tables */
1064: /* Called from : Depot Repair Form to Update DR specifc Task */
1065: /* Input Parm : p_api_version NUMBER Required Api Version number */
1066: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1067: /* default value is fnd_api.g_false */
1068: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1069: /* fnd_api.g_false */
1070: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 1067: /* default value is fnd_api.g_false */

1063: /* description : procedure used to update DR specifc task in Depot tables */
1064: /* Called from : Depot Repair Form to Update DR specifc Task */
1065: /* Input Parm : p_api_version NUMBER Required Api Version number */
1066: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1067: /* default value is fnd_api.g_false */
1068: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1069: /* fnd_api.g_false */
1070: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1071: /* validation steps must be done and which steps */

Line 1068: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

1064: /* Called from : Depot Repair Form to Update DR specifc Task */
1065: /* Input Parm : p_api_version NUMBER Required Api Version number */
1066: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1067: /* default value is fnd_api.g_false */
1068: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1069: /* fnd_api.g_false */
1070: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1071: /* validation steps must be done and which steps */
1072: /* should be skipped. */

Line 1069: /* fnd_api.g_false */

1065: /* Input Parm : p_api_version NUMBER Required Api Version number */
1066: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
1067: /* default value is fnd_api.g_false */
1068: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
1069: /* fnd_api.g_false */
1070: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
1071: /* validation steps must be done and which steps */
1072: /* should be skipped. */
1073: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */

Line 1075: /* fnd_api.g_ret_sts_success (success) */

1071: /* validation steps must be done and which steps */
1072: /* should be skipped. */
1073: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1074: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1075: /* fnd_api.g_ret_sts_success (success) */
1076: /* fnd_api.g_ret_sts_error (error) */
1077: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1078: /* x_msg_count NUMBER Number of messages in the message stack */
1079: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 1076: /* fnd_api.g_ret_sts_error (error) */

1072: /* should be skipped. */
1073: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1074: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1075: /* fnd_api.g_ret_sts_success (success) */
1076: /* fnd_api.g_ret_sts_error (error) */
1077: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1078: /* x_msg_count NUMBER Number of messages in the message stack */
1079: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1080: /*-----------------------------------------------------------------------------------------------------------*/

Line 1077: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

1073: /* CREATE_REPAIR_TASK_REC RECORD Required Columns are in the Record CREATE_REPAIR_TASK_REC_TYPE */
1074: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1075: /* fnd_api.g_ret_sts_success (success) */
1076: /* fnd_api.g_ret_sts_error (error) */
1077: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1078: /* x_msg_count NUMBER Number of messages in the message stack */
1079: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
1080: /*-----------------------------------------------------------------------------------------------------------*/
1081:

Line 1084: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1080: /*-----------------------------------------------------------------------------------------------------------*/
1081:
1082: procedure UPDATE_REPAIR_TASK
1083: ( p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1085: p_commit IN VARCHAR2 := fnd_api.g_false,
1086: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1087: p_update_repair_task_rec IN REPAIR_TASK_REC,
1088: x_return_status OUT NOCOPY VARCHAR2,

Line 1085: p_commit IN VARCHAR2 := fnd_api.g_false,

1081:
1082: procedure UPDATE_REPAIR_TASK
1083: ( p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1085: p_commit IN VARCHAR2 := fnd_api.g_false,
1086: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1087: p_update_repair_task_rec IN REPAIR_TASK_REC,
1088: x_return_status OUT NOCOPY VARCHAR2,
1089: x_msg_count OUT NOCOPY NUMBER,

Line 1086: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1082: procedure UPDATE_REPAIR_TASK
1083: ( p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1085: p_commit IN VARCHAR2 := fnd_api.g_false,
1086: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1087: p_update_repair_task_rec IN REPAIR_TASK_REC,
1088: x_return_status OUT NOCOPY VARCHAR2,
1089: x_msg_count OUT NOCOPY NUMBER,
1090: x_msg_data OUT NOCOPY VARCHAR2