DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_PVT dependencies on FND_GLOBAL

Line 22: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676

18: ,p_classification_code IN NUMBER
19: ,p_reason_code IN NUMBER
20: ,p_project_id IN NUMBER
21: ,p_last_modified_by_id IN NUMBER
22: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
23: ,p_object_type IN VARCHAR2 := NULL
24: ,p_object_id IN NUMBER := NULL
25: ,p_ci_number IN VARCHAR2 := NULL
26: ,p_date_required IN DATE := NULL

Line 403: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676

399: ,p_reason_code IN NUMBER
400: ,p_record_version_number IN NUMBER
401: ,p_project_id IN NUMBER
402: ,p_last_modified_by_id IN NUMBER
403: := NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id) -- 26-Jun-2009 cklee Modified for the Bug# 8633676
404: ,p_object_type IN VARCHAR2 := NULL
405: ,p_object_id IN NUMBER := NULL
406: ,p_ci_number IN VARCHAR2 := NULL
407: ,p_date_required IN DATE := NULL

Line 1186: -- ,p_last_modified_by_id => PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id )

1182: ,p_classification_code => l_class_code
1183: ,p_reason_code => l_reason
1184: ,p_project_id => p_project_id
1185: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
1186: -- ,p_last_modified_by_id => PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id )
1187: ,p_last_modified_by_id => NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)
1188: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1189: ,p_object_type => copy_from_row.object_type
1190: ,p_object_id => copy_from_row.object_id

Line 1187: ,p_last_modified_by_id => NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)

1183: ,p_reason_code => l_reason
1184: ,p_project_id => p_project_id
1185: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
1186: -- ,p_last_modified_by_id => PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id )
1187: ,p_last_modified_by_id => NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)
1188: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1189: ,p_object_type => copy_from_row.object_type
1190: ,p_object_id => copy_from_row.object_id
1191: ,p_ci_number => p_ci_number

Line 1448: p_user_id => fnd_global.user_id,

1444: end if;
1445:
1446: if (x_return_status = 'S') then
1447: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1448: p_user_id => fnd_global.user_id,
1449: p_object_type_from => 'PA_CONTROL_ITEMS',
1450: p_object_id_from1 => to_char(p_from_ci_id),
1451: p_object_id_from2 => NULL,
1452: p_object_id_from3 => NULL,

Line 1545: ,p_last_updated_by in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985

1541: ,x_num_of_actions OUT NOCOPY NUMBER
1542: ,x_return_status OUT NOCOPY VARCHAR2
1543: ,x_msg_count OUT NOCOPY NUMBER
1544: ,x_msg_data OUT NOCOPY VARCHAR2
1545: ,p_last_updated_by in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
1546: ,p_last_update_date in DATE default sysdate --Added the parameter for bug# 3877985
1547: ,p_last_update_login in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
1548: )IS
1549: l_nof_actions NUMBER(15) := 0;

Line 1547: ,p_last_update_login in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985

1543: ,x_msg_count OUT NOCOPY NUMBER
1544: ,x_msg_data OUT NOCOPY VARCHAR2
1545: ,p_last_updated_by in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
1546: ,p_last_update_date in DATE default sysdate --Added the parameter for bug# 3877985
1547: ,p_last_update_login in NUMBER default fnd_global.user_id --Added the parameter for bug# 3877985
1548: )IS
1549: l_nof_actions NUMBER(15) := 0;
1550:
1551: cp pa_control_items%ROWTYPE;

Line 1607: ,NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)

1603: ,p_record_version_number
1604: ,cp.project_id
1605: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
1606: -- ,cp.last_modified_by_id
1607: ,NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)
1608: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1609: ,cp.object_type
1610: ,cp.object_id
1611: ,cp.ci_number

Line 1863: l_closed_by := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );

1859: -- x_return_status := 'E';
1860: -- PA_DEBUG.Reset_Err_Stack;
1861: -- return;
1862: -- END IF;
1863: l_closed_by := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
1864: l_closed_date := sysdate;
1865: end if;
1866: end if;
1867:

Line 1882: -- ,PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ) --cp.last_modified_by_id

1878: ,cp.reason_code_id
1879: ,p_record_version_number
1880: ,cp.project_id
1881: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
1882: -- ,PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ) --cp.last_modified_by_id
1883: ,NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)
1884: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1885: ,cp.object_type
1886: ,cp.object_id

Line 1883: ,NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)

1879: ,p_record_version_number
1880: ,cp.project_id
1881: -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
1882: -- ,PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ) --cp.last_modified_by_id
1883: ,NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id)
1884: -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
1885: ,cp.object_type
1886: ,cp.object_id
1887: ,l_ci_number_char --cp.ci_number

Line 2182: p_user_id => fnd_global.user_id,

2178: RETURN;
2179: END IF;
2180:
2181: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
2182: p_user_id => fnd_global.user_id,
2183: p_object_type_from => 'PA_CONTROL_ITEMS',
2184: p_object_id_from1 => to_char(p_ci_id),
2185: p_object_id_from2 => NULL,
2186: p_object_id_from3 => NULL,

Line 2742: ,p_last_modified_by_id => NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id ) --cp.last_modified_by_id

2738: ,p_classification_code => cp.classification_code_id
2739: ,p_reason_code => cp.reason_code_id
2740: ,p_record_version_number=> cp.record_version_number
2741: ,p_project_id => cp.project_id
2742: ,p_last_modified_by_id => NVL(PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id ), fnd_global.user_id ) --cp.last_modified_by_id
2743: ,p_object_type => cp.object_type
2744: ,p_object_id => cp.object_id
2745: ,p_ci_number => cp.ci_number
2746: ,p_date_required => cp.date_required

Line 2794: ,p_last_updated_by => fnd_global.user_id

2790: ,p_change_approver => cp.change_approver
2791: ,x_return_status => x_return_status
2792: ,x_msg_count => x_msg_count
2793: ,x_msg_data => x_msg_data
2794: ,p_last_updated_by => fnd_global.user_id
2795: ,p_last_update_date => sysdate
2796: ,p_last_update_login => fnd_global.user_id
2797: );
2798:

Line 2796: ,p_last_update_login => fnd_global.user_id

2792: ,x_msg_count => x_msg_count
2793: ,x_msg_data => x_msg_data
2794: ,p_last_updated_by => fnd_global.user_id
2795: ,p_last_update_date => sysdate
2796: ,p_last_update_login => fnd_global.user_id
2797: );
2798:
2799: END IF;
2800: -- Commit if the flag is set and there is no error