eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on IGS_SC_USR_ATTRIBS_S

Line 1529: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

1525: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1526: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
1527: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
1528: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
1529: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
1530: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
1531: p_active_flag IN VARCHAR2 DEFAULT 'Y',
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_return_message OUT NOCOPY VARCHAR2

Line 1530: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

1526: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,
1527: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
1528: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
1529: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
1530: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
1531: p_active_flag IN VARCHAR2 DEFAULT 'Y',
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_return_message OUT NOCOPY VARCHAR2
1534: ) IS

Line 1545: l_static_type igs_sc_usr_attribs.static_type%TYPE;

1541: l_return_message VARCHAR2(2000);
1542: l_message_count NUMBER(15);
1543: l_return_status VARCHAR2(30);
1544: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;
1545: l_static_type igs_sc_usr_attribs.static_type%TYPE;
1546:
1547: BEGIN
1548:
1549: SAVEPOINT Insert_User_Attr_SP;

Line 1654: VALUES ( NVL(p_user_attrib_id,igs_sc_usr_attribs_s.nextval),

1650: last_update_date,
1651: last_update_login,
1652: active_flag
1653: )
1654: VALUES ( NVL(p_user_attrib_id,igs_sc_usr_attribs_s.nextval),
1655: p_user_attrib_name,
1656: l_user_attrib_type,
1657: l_static_type,
1658: p_select_text,

Line 3985: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,

3981: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3982: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
3983: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
3984: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
3985: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
3986: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
3987: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
3988: x_return_status OUT NOCOPY VARCHAR2,
3989: x_return_message OUT NOCOPY VARCHAR2

Line 3986: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,

3982: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
3983: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,
3984: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,
3985: p_static_type IN igs_sc_usr_attribs.static_type%TYPE,
3986: p_select_text IN igs_sc_usr_attribs.select_text%TYPE,
3987: p_active_flag IN igs_sc_usr_attribs.active_flag%TYPE,
3988: x_return_status OUT NOCOPY VARCHAR2,
3989: x_return_message OUT NOCOPY VARCHAR2
3990: ) IS

Line 4003: l_static_type igs_sc_usr_attribs.static_type%TYPE;

3999: l_message_count NUMBER(15);
4000: l_return_status VARCHAR2(30);
4001: l_user_attrib_name igs_sc_usr_attribs.user_attrib_name%TYPE;
4002: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;
4003: l_static_type igs_sc_usr_attribs.static_type%TYPE;
4004: l_select_text igs_sc_usr_attribs.select_text%TYPE;
4005: l_grant_name igs_sc_grants.grant_name%TYPE;
4006: l_grant_id igs_sc_grants.grant_id%TYPE;
4007:

Line 4004: l_select_text igs_sc_usr_attribs.select_text%TYPE;

4000: l_return_status VARCHAR2(30);
4001: l_user_attrib_name igs_sc_usr_attribs.user_attrib_name%TYPE;
4002: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;
4003: l_static_type igs_sc_usr_attribs.static_type%TYPE;
4004: l_select_text igs_sc_usr_attribs.select_text%TYPE;
4005: l_grant_name igs_sc_grants.grant_name%TYPE;
4006: l_grant_id igs_sc_grants.grant_id%TYPE;
4007:
4008: -- -----------------------------------------------------------------

Line 7891: UPDATE igs_sc_usr_attribs SET user_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_usr_attribs_c;

7887: UPDATE IGS_SC_GRANT_CONDS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7888: UPDATE IGS_SC_USR_ATT_VALS SET user_attrib_id = l_current_seq WHERE user_attrib_id = igs_sc_usr_attribs_rec.user_attrib_id;
7889:
7890: -- Update table itself
7891: UPDATE igs_sc_usr_attribs SET user_attrib_id = l_current_seq WHERE CURRENT OF igs_sc_usr_attribs_c;
7892:
7893: END IF;
7894:
7895: l_current_seq := l_current_seq +1;