98: attribute15
99: )
100: VALUES
101: (
102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
99: )
100: VALUES
101: (
102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
100: VALUES
101: (
102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
101: (
102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),
109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),
117: x_attribute1,
110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),
117: x_attribute1,
118: x_attribute2,
111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),
117: x_attribute1,
118: x_attribute2,
119: x_attribute3,
112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),
113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),
114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),
115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),
116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),
117: x_attribute1,
118: x_attribute2,
119: x_attribute3,
120: x_attribute4,
356: IS
357: begin
358: update csc_customers
359: set
360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),
361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),
362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_date)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
357: begin
358: update csc_customers
359: set
360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),
361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),
362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_date)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
358: update csc_customers
359: set
360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),
361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),
362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_date)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
359: set
360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),
361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),
362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_date)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),
361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),
362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_date)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_by)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
365: --creation_date = x_creation_date,
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
366: --created_by = x_created_by,
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),
367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_flag)),
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),
375: attribute1 = x_attribute1,
368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),
375: attribute1 = x_attribute1,
376: attribute2 = x_attribute2,
369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),
375: attribute1 = x_attribute1,
376: attribute2 = x_attribute2,
377: attribute3 = x_attribute3,
370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),
371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),
372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),
373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),
374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),
375: attribute1 = x_attribute1,
376: attribute2 = x_attribute2,
377: attribute3 = x_attribute3,
378: attribute4 = x_attribute4,