DBA Data[Home] [Help]

APPS.CSC_CUSTOMERS_PKG dependencies on FND_API

Line 102: DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,x_party_id),

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

Line 103: DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,x_cust_account_id),

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

Line 104: DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_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),

Line 105: DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_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),

Line 106: DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login),

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

Line 107: DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date),

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

Line 108: DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by),

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

Line 109: DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,x_override_flag),

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

Line 110: DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,x_overridden_critical_flag),

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

Line 111: DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,x_override_reason_code),

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

Line 112: DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,p_party_status),

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

Line 113: DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,p_request_id),

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,

Line 114: DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,p_program_application_id),

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,

Line 115: DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,p_program_id),

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,

Line 116: DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,p_program_update_date),

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,

Line 360: party_id = DECODE(x_party_id,FND_API.G_MISS_NUM,NULL,NVL(x_party_id,party_id)),

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

Line 361: cust_account_id = DECODE(x_cust_account_id,FND_API.G_MISS_NUM,NULL,NVL(x_cust_account_id,cust_account_id)),

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,

Line 362: last_update_date = DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,NVL(x_last_update_date,last_update_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,

Line 363: last_updated_by = DECODE(x_last_updated_by,FND_API.G_MISS_CHAR,NULL,NVL(x_last_updated_by,last_updated_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)),

Line 364: last_update_login = DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,NVL(x_last_update_login,last_update_login)),

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

Line 367: override_flag = DECODE(x_override_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_override_flag,override_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)),

Line 368: overridden_critical_flag = DECODE(x_overridden_critical_flag,FND_API.G_MISS_CHAR,NULL,NVL(x_overridden_critical_flag,overridden_critical_flag)),

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

Line 369: override_reason_code = DECODE(x_override_reason_code,FND_API.G_MISS_CHAR,NULL,NVL(x_override_reason_code,override_reason_code)),

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

Line 370: party_status = DECODE(p_party_status,FND_API.G_MISS_CHAR,NULL,NVL(p_party_status,party_status)),

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

Line 371: request_id = DECODE(p_request_id,FND_API.G_MISS_NUM,NULL,NVL(p_request_id,request_id)),

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,

Line 372: program_application_id = DECODE(p_program_application_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_application_id,program_application_id)),

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,

Line 373: program_id = DECODE(p_program_id,FND_API.G_MISS_NUM,NULL,NVL(p_program_id,program_id)),

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,

Line 374: program_update_date = DECODE(p_program_update_date,FND_API.G_MISS_DATE,NULL,NVL(p_program_update_date,program_update_date)),

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,