DBA Data[Home] [Help]

APPS.JTF_IH_OUTCOME_RSLTS_SEED_PUB dependencies on FND_API

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

27: , last_update_date
28: , last_update_login
29: ) VALUES (
30: x_result_id
31: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

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

28: , last_update_login
29: ) VALUES (
30: x_result_id
31: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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

29: ) VALUES (
30: x_result_id
31: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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

30: x_result_id
31: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );

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

31: , DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:

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

32: , DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:
40: OPEN l_insert;

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

33: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
34: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
35: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
36: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
37: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
38: );
39:
40: OPEN l_insert;
41: FETCH l_insert INTO x_rowid;

Line 73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)

69: ) IS
70: BEGIN
71: UPDATE jtf_ih_outcome_results
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

Line 74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)

70: BEGIN
71: UPDATE jtf_ih_outcome_results
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

Line 75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)

71: UPDATE jtf_ih_outcome_results
72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

Line 76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

72: SET
73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

Line 77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

73: result_id=DECODE(x_result_id,FND_API.G_MISS_NUM,NULL,x_result_id)
74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;

Line 78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

74: , outcome_id=DECODE(x_outcome_id,FND_API.G_MISS_NUM,NULL,x_outcome_id)
75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN

Line 79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

75: , object_version_number=DECODE(x_object_version_number,FND_API.G_MISS_NUM,NULL,x_object_version_number)
76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN
83: RAISE NO_DATA_FOUND;

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

76: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
77: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
78: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
79: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
80: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
81: WHERE ROWID = x_rowid;
82: IF (SQL%NOTFOUND) THEN
83: RAISE NO_DATA_FOUND;
84: END IF;