DBA Data[Home] [Help]

APPS.CS_SR_PARTY_MERGE_PKG dependencies on FND_GLOBAL

Line 6: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;

2: /* $Header: cssrpmgb.pls 120.1 2005/12/22 17:29:27 spusegao noship $ */
3:
4:
5: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CS_SR_PARTY_MERGE_PKG';
6: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
7: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8:
9: TYPE ROWID_TBL IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
10: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 7: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;

3:
4:
5: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CS_SR_PARTY_MERGE_PKG';
6: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
7: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
8:
9: TYPE ROWID_TBL IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
10: TYPE NUM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11: TYPE VARCHAR2_30_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 1329: p_cp_modified_by => fnd_global.user_id,

1325: (p_sr_contact_point_id => p_from_id,
1326: p_incident_id => l_incident_id(i),
1327: p_new_cp_rec => l_sr_contact_new_rec,
1328: p_old_cp_rec => l_sr_contact_old_rec,
1329: p_cp_modified_by => fnd_global.user_id,
1330: p_cp_modified_on => sysdate,
1331: x_return_status => l_return_status,
1332: x_msg_count => x_msg_count,
1333: x_msg_data => x_msg_data ) ;

Line 1420: p_cp_modified_by => fnd_global.user_id,

1416: (p_sr_contact_point_id => p_from_id,
1417: p_incident_id => l_incident_id(i),
1418: p_new_cp_rec => l_sr_contact_new_rec,
1419: p_old_cp_rec => l_sr_contact_old_rec,
1420: p_cp_modified_by => fnd_global.user_id,
1421: p_cp_modified_on => sysdate,
1422: x_return_status => l_return_status,
1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data ) ;

Line 1497: p_cp_modified_by => fnd_global.user_id,

1493: (p_sr_contact_point_id => p_from_id,
1494: p_incident_id => l_incident_id(i),
1495: p_new_cp_rec => l_sr_contact_new_rec,
1496: p_old_cp_rec => l_sr_contact_old_rec,
1497: p_cp_modified_by => fnd_global.user_id,
1498: p_cp_modified_on => sysdate,
1499: x_return_status => l_return_status,
1500: x_msg_count => x_msg_count,
1501: x_msg_data => x_msg_data ) ;

Line 1730: p_cp_modified_by => fnd_global.user_id,

1726: (p_sr_contact_point_id => p_from_id,
1727: p_incident_id => l_incident_id(i),
1728: p_new_cp_rec => l_sr_contact_new_rec,
1729: p_old_cp_rec => l_sr_contact_old_rec,
1730: p_cp_modified_by => fnd_global.user_id,
1731: p_cp_modified_on => sysdate,
1732: x_return_status => l_return_status,
1733: x_msg_count => x_msg_count,
1734: x_msg_data => x_msg_data ) ;

Line 1817: p_cp_modified_by => fnd_global.user_id,

1813: (p_sr_contact_point_id => p_from_id,
1814: p_incident_id => l_incident_id(i),
1815: p_new_cp_rec => l_sr_contact_new_rec,
1816: p_old_cp_rec => l_sr_contact_old_rec,
1817: p_cp_modified_by => fnd_global.user_id,
1818: p_cp_modified_on => sysdate,
1819: x_return_status => l_return_status,
1820: x_msg_count => x_msg_count,
1821: x_msg_data => x_msg_data ) ;

Line 1891: p_cp_modified_by => fnd_global.user_id,

1887: (p_sr_contact_point_id => p_from_id,
1888: p_incident_id => l_incident_id(i),
1889: p_new_cp_rec => l_sr_contact_new_rec,
1890: p_old_cp_rec => l_sr_contact_old_rec,
1891: p_cp_modified_by => fnd_global.user_id,
1892: p_cp_modified_on => sysdate,
1893: x_return_status => l_return_status,
1894: x_msg_count => x_msg_count,
1895: x_msg_data => x_msg_data ) ;