DBA Data[Home] [Help]

APPS.JTF_IH_WRAP_UPS_SEED_PUB dependencies on FND_API

Line 58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)

54: , end_date
55: , wrap_up_level
56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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

55: , wrap_up_level
56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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

56: ) VALUES (
57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)

Line 61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

57: x_wrap_id
58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)

Line 62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

58: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)

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

59: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)

Line 64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)

60: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)

Line 65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)

61: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)

Line 66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)

62: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)

Line 67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)

63: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)

Line 68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)

64: , DECODE(x_outcome_required,FND_API.G_MISS_CHAR,NULL,x_outcome_required)
65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)

Line 69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)

65: , DECODE(x_result_required,FND_API.G_MISS_CHAR,NULL,x_result_required)
66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)

Line 70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)

66: , DECODE(x_reason_required,FND_API.G_MISS_CHAR,NULL,x_reason_required)
67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)

Line 71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)

67: , DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)

Line 72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)

68: , DECODE(x_reason_id,FND_API.G_MISS_NUM,NULL,x_reason_id)
69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date

Line 73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)

69: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)

Line 74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)

70: , DECODE(x_action_activity_id,FND_API.G_MISS_NUM,NULL,x_action_activity_id)
71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );

Line 75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)

71: , DECODE(x_object_id,FND_API.G_MISS_NUM,NULL,x_object_id)
72: , DECODE(x_object_type,FND_API.G_MISS_CHAR,NULL,x_object_type)
73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );
79:

Line 77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)

73: , DECODE(x_source_code_id,FND_API.G_MISS_NUM,NULL,x_source_code_id)
74: , DECODE(x_source_code,FND_API.G_MISS_CHAR,NULL,x_source_code)
75: , DECODE(x_start_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, x_start_date)
76: , x_end_date
77: , DECODE(x_wrap_up_level, FND_API.G_MISS_CHAR,'BOTH',NULL,'BOTH',x_wrap_up_level)
78: );
79:
80: OPEN l_insert;
81: FETCH l_insert INTO x_rowid;