DBA Data[Home] [Help]

APPS.JTF_NOTES_PUB dependencies on FND_GLOBAL

Line 27: , p_entered_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

23: , p_source_object_code IN VARCHAR2 DEFAULT CHR(0)
24: , p_notes IN VARCHAR2 DEFAULT CHR(0)
25: , p_notes_detail IN VARCHAR2 DEFAULT NULL
26: , p_note_status IN VARCHAR2 DEFAULT 'I'
27: , p_entered_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
28: , p_entered_date IN DATE DEFAULT TO_DATE('1','j')
29: , x_jtf_note_id OUT NOCOPY NUMBER
30: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
31: , p_last_updated_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

Line 31: , p_last_updated_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

27: , p_entered_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
28: , p_entered_date IN DATE DEFAULT TO_DATE('1','j')
29: , x_jtf_note_id OUT NOCOPY NUMBER
30: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
31: , p_last_updated_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
32: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
33: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
34: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
35: , p_attribute1 IN VARCHAR2 DEFAULT NULL

Line 33: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

29: , x_jtf_note_id OUT NOCOPY NUMBER
30: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
31: , p_last_updated_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
32: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
33: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
34: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
35: , p_attribute1 IN VARCHAR2 DEFAULT NULL
36: , p_attribute2 IN VARCHAR2 DEFAULT NULL
37: , p_attribute3 IN VARCHAR2 DEFAULT NULL

Line 34: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID

30: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
31: , p_last_updated_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
32: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
33: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
34: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
35: , p_attribute1 IN VARCHAR2 DEFAULT NULL
36: , p_attribute2 IN VARCHAR2 DEFAULT NULL
37: , p_attribute3 IN VARCHAR2 DEFAULT NULL
38: , p_attribute4 IN VARCHAR2 DEFAULT NULL

Line 188: , p_entered_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

184: , x_return_status OUT NOCOPY VARCHAR2
185: , x_msg_count OUT NOCOPY NUMBER
186: , x_msg_data OUT NOCOPY VARCHAR2
187: , p_jtf_note_id IN NUMBER
188: , p_entered_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
189: , p_last_updated_by IN NUMBER
190: , p_last_update_date IN DATE DEFAULT SYSDATE
191: , p_last_update_login IN NUMBER DEFAULT NULL
192: , p_notes IN VARCHAR2 DEFAULT CHR(0)

Line 361: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID

357: , p_jtf_note_id IN NUMBER
358: , p_last_update_date IN DATE
359: , p_last_updated_by IN NUMBER
360: , p_creation_date IN DATE
361: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
362: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
363: , p_note_context_type_id IN NUMBER DEFAULT 9.99E125
364: , p_note_context_type IN VARCHAR2 DEFAULT CHR(0)
365: , x_note_context_id OUT NOCOPY NUMBER

Line 362: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID

358: , p_last_update_date IN DATE
359: , p_last_updated_by IN NUMBER
360: , p_creation_date IN DATE
361: , p_created_by IN NUMBER DEFAULT FND_GLOBAL.USER_ID
362: , p_last_update_login IN NUMBER DEFAULT FND_GLOBAL.LOGIN_ID
363: , p_note_context_type_id IN NUMBER DEFAULT 9.99E125
364: , p_note_context_type IN VARCHAR2 DEFAULT CHR(0)
365: , x_note_context_id OUT NOCOPY NUMBER
366: )

Line 1179: , p_entered_by IN NUMBER DEFAULT fnd_global.user_id

1175: , p_source_object_code IN VARCHAR2 DEFAULT CHR(0)
1176: , p_notes IN VARCHAR2 DEFAULT CHR(0)
1177: , p_notes_detail IN VARCHAR2 DEFAULT NULL
1178: , p_note_status IN VARCHAR2 DEFAULT 'I'
1179: , p_entered_by IN NUMBER DEFAULT fnd_global.user_id
1180: , p_entered_date IN DATE DEFAULT TO_DATE('1','j')
1181: , x_jtf_note_id OUT NOCOPY NUMBER
1182: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
1183: , p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id

Line 1183: , p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id

1179: , p_entered_by IN NUMBER DEFAULT fnd_global.user_id
1180: , p_entered_date IN DATE DEFAULT TO_DATE('1','j')
1181: , x_jtf_note_id OUT NOCOPY NUMBER
1182: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
1183: , p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id
1184: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
1185: , p_created_by IN NUMBER DEFAULT fnd_global.user_id
1186: , p_last_update_login IN NUMBER DEFAULT fnd_global.login_id
1187: , p_attribute1 IN VARCHAR2 DEFAULT NULL

Line 1185: , p_created_by IN NUMBER DEFAULT fnd_global.user_id

1181: , x_jtf_note_id OUT NOCOPY NUMBER
1182: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
1183: , p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id
1184: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
1185: , p_created_by IN NUMBER DEFAULT fnd_global.user_id
1186: , p_last_update_login IN NUMBER DEFAULT fnd_global.login_id
1187: , p_attribute1 IN VARCHAR2 DEFAULT NULL
1188: , p_attribute2 IN VARCHAR2 DEFAULT NULL
1189: , p_attribute3 IN VARCHAR2 DEFAULT NULL

Line 1186: , p_last_update_login IN NUMBER DEFAULT fnd_global.login_id

1182: , p_last_update_date IN DATE DEFAULT TO_DATE('1','j')
1183: , p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id
1184: , p_creation_date IN DATE DEFAULT TO_DATE('1','j')
1185: , p_created_by IN NUMBER DEFAULT fnd_global.user_id
1186: , p_last_update_login IN NUMBER DEFAULT fnd_global.login_id
1187: , p_attribute1 IN VARCHAR2 DEFAULT NULL
1188: , p_attribute2 IN VARCHAR2 DEFAULT NULL
1189: , p_attribute3 IN VARCHAR2 DEFAULT NULL
1190: , p_attribute4 IN VARCHAR2 DEFAULT NULL

Line 2012: , p_entered_by IN NUMBER DEFAULT fnd_global.user_id

2008: , x_return_status OUT NOCOPY VARCHAR2
2009: , x_msg_count OUT NOCOPY NUMBER
2010: , x_msg_data OUT NOCOPY VARCHAR2
2011: , p_jtf_note_id IN NUMBER
2012: , p_entered_by IN NUMBER DEFAULT fnd_global.user_id
2013: , p_last_updated_by IN NUMBER
2014: , p_last_update_date IN DATE DEFAULT SYSDATE
2015: , p_last_update_login IN NUMBER DEFAULT NULL
2016: , p_notes IN VARCHAR2 DEFAULT CHR(0)

Line 2196: l_last_updated_by := FND_GLOBAL.USER_ID;

2192: END IF;
2193: --
2194: IF p_last_updated_by = fnd_api.g_miss_num
2195: THEN
2196: l_last_updated_by := FND_GLOBAL.USER_ID;
2197: ELSE
2198: l_last_updated_by := p_last_updated_by;
2199: END IF;
2200: --

Line 2203: l_last_update_login := FND_GLOBAL.USER_ID;

2199: END IF;
2200: --
2201: IF p_last_update_login = fnd_api.g_miss_num
2202: THEN
2203: l_last_update_login := FND_GLOBAL.USER_ID;
2204: ELSE
2205: l_last_update_login := p_last_update_login;
2206: END IF;
2207: --