55: p_program_id NUMBER,
56: p_program_update_date DATE);
57:
58: PROCEDURE update_row(
59: p_system_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
56: p_program_update_date DATE);
57:
58: PROCEDURE update_row(
59: p_system_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
57:
58: PROCEDURE update_row(
59: p_system_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
58: PROCEDURE update_row(
59: p_system_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
59: p_system_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
60: p_customer_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
61: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
62: p_system_number VARCHAR2 := fnd_api.g_miss_char,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
63: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
64: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
65: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
66: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
67: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
68: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
69: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
70: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
71: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
72: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
73: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
74: p_start_date_active DATE := fnd_api.g_miss_date,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
75: p_end_date_active DATE := fnd_api.g_miss_date,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
76: p_context VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
77: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
78: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
79: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
80: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
81: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
82: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
83: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
84: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
85: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
86: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
87: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
88: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
89: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
90: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
91: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
92: p_created_by NUMBER := fnd_api.g_miss_num ,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
100: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
93: p_creation_date DATE := fnd_api.g_miss_date,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
100: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
101: p_request_id NUMBER ,
94: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
100: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
101: p_request_id NUMBER ,
102: p_program_application_id NUMBER ,
95: p_last_update_date DATE := fnd_api.g_miss_date,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
100: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
101: p_request_id NUMBER ,
102: p_program_application_id NUMBER ,
103: p_program_id NUMBER ,
96: p_last_update_login NUMBER := fnd_api.g_miss_num ,
97: p_object_version_number NUMBER := fnd_api.g_miss_num ,
98: p_name VARCHAR2 := fnd_api.g_miss_char,
99: p_description VARCHAR2 := fnd_api.g_miss_char,
100: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
101: p_request_id NUMBER ,
102: p_program_application_id NUMBER ,
103: p_program_id NUMBER ,
104: p_program_update_date DATE );
103: p_program_id NUMBER ,
104: p_program_update_date DATE );
105:
106: PROCEDURE update_row_for_mu(
107: p_system_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
104: p_program_update_date DATE );
105:
106: PROCEDURE update_row_for_mu(
107: p_system_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
105:
106: PROCEDURE update_row_for_mu(
107: p_system_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
106: PROCEDURE update_row_for_mu(
107: p_system_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
107: p_system_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
108: p_customer_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
109: p_system_type_code VARCHAR2 := fnd_api.g_miss_char,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
110: p_system_number VARCHAR2 := fnd_api.g_miss_char,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
111: p_parent_system_id NUMBER := fnd_api.g_miss_num ,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
112: p_ship_to_contact_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
113: p_bill_to_contact_id NUMBER := fnd_api.g_miss_num ,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
114: p_technical_contact_id NUMBER := fnd_api.g_miss_num ,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
115: p_service_admin_contact_id NUMBER := fnd_api.g_miss_num ,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
116: p_ship_to_site_use_id NUMBER := fnd_api.g_miss_num ,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
117: p_bill_to_site_use_id NUMBER := fnd_api.g_miss_num ,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
118: p_install_site_use_id NUMBER := fnd_api.g_miss_num ,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
119: p_coterminate_day_month VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
120: p_autocreated_FROM_system_id NUMBER := fnd_api.g_miss_num ,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
121: p_config_system_type VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
122: p_start_date_active DATE := fnd_api.g_miss_date,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
123: p_end_date_active DATE := fnd_api.g_miss_date,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
124: p_context VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
125: p_attribute1 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
126: p_attribute2 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
127: p_attribute3 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
128: p_attribute4 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
129: p_attribute5 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
130: p_attribute6 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
131: p_attribute7 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
132: p_attribute8 VARCHAR2 := fnd_api.g_miss_char,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
133: p_attribute9 VARCHAR2 := fnd_api.g_miss_char,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
134: p_attribute10 VARCHAR2 := fnd_api.g_miss_char,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
135: p_attribute11 VARCHAR2 := fnd_api.g_miss_char,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
136: p_attribute12 VARCHAR2 := fnd_api.g_miss_char,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
137: p_attribute13 VARCHAR2 := fnd_api.g_miss_char,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
138: p_attribute14 VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
139: p_attribute15 VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
140: p_created_by NUMBER := fnd_api.g_miss_num ,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
148: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
141: p_creation_date DATE := fnd_api.g_miss_date,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
148: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
149: p_request_id NUMBER ,
142: p_last_updated_by NUMBER := fnd_api.g_miss_num ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
148: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
149: p_request_id NUMBER ,
150: p_program_application_id NUMBER ,
143: p_last_update_date DATE := fnd_api.g_miss_date,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
148: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
149: p_request_id NUMBER ,
150: p_program_application_id NUMBER ,
151: p_program_id NUMBER ,
144: p_last_update_login NUMBER := fnd_api.g_miss_num ,
145: p_object_version_number NUMBER := fnd_api.g_miss_num ,
146: p_name VARCHAR2 := fnd_api.g_miss_char,
147: p_description VARCHAR2 := fnd_api.g_miss_char,
148: p_operating_unit_id NUMBER := fnd_api.g_miss_num,
149: p_request_id NUMBER ,
150: p_program_application_id NUMBER ,
151: p_program_id NUMBER ,
152: p_program_update_date DATE );