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

Line 383: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE := p_user_attrib_id;

379: l_api_version CONSTANT NUMBER := 1.0;
380: l_return_message VARCHAR2(2000);
381: l_message_count NUMBER(15);
382: l_return_status VARCHAR2(30);
383: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE := p_user_attrib_id;
384: l_obj_attr_id igs_sc_obj_attribs.obj_attrib_id%TYPE := p_obj_attrib_id;
385: l_grant_id igs_sc_grants.grant_id%TYPE := p_grant_id;
386:
387: BEGIN

Line 1512: igs_sc_usr_attribs. There is validation

1508: Created By : Don Shellito
1509: Date Created By : April 23, 2003
1510: Purpose : The purpose of this procedure is to handle
1511: the insertion of data into the table
1512: igs_sc_usr_attribs. There is validation
1513: to ensure that the static_type and
1514: user_attrib_type are valid values.
1515: Remarks :
1516:

Line 1526: p_user_attrib_id IN OUT NOCOPY igs_sc_usr_attribs.user_attrib_id%TYPE,

1522: *****************************************************************/
1523: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
1524: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 1527: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,

1523: PROCEDURE Insert_User_Attr (p_api_version IN NUMBER,
1524: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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',

Line 1528: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

1524: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

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 1544: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;

1540: l_api_version CONSTANT NUMBER := 1.0;
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:

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 1641: INTO igs_sc_usr_attribs

1637: -- -----------------------------------------------------------------
1638: -- Insert the values requested into the Grants table.
1639: -- -----------------------------------------------------------------
1640: INSERT
1641: INTO igs_sc_usr_attribs
1642: (user_attrib_id,
1643: user_attrib_name,
1644: user_attrib_type,
1645: static_type,

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 3968: that are required to the table igs_sc_usr_attribs.

3964: /******************************************************************
3965: Created By : Don Shellito
3966: Date Created By : April 23, 2003
3967: Purpose : The purpose of this procedure is for the updates
3968: that are required to the table igs_sc_usr_attribs.
3969: There is validation on the types and the IDs to
3970: ensure data is in OSS data model and for integrity.
3971: Remarks :
3972:

Line 3982: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

3978: ******************************************************************/
3979: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
3980: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 3983: p_user_attrib_name IN igs_sc_usr_attribs.user_attrib_name%TYPE,

3979: PROCEDURE Update_User_Attr (p_api_version IN NUMBER,
3980: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

Line 3984: p_user_attrib_type IN igs_sc_usr_attribs.user_attrib_type%TYPE,

3980: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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,

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 3987: p_active_flag IN igs_sc_usr_attribs.active_flag%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
3991:

Line 4001: l_user_attrib_name igs_sc_usr_attribs.user_attrib_name%TYPE;

3997: l_api_version CONSTANT NUMBER := 1.0;
3998: l_return_message VARCHAR2(2000);
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;

Line 4002: l_user_attrib_type igs_sc_usr_attribs.user_attrib_type%TYPE;

3998: l_return_message VARCHAR2(2000);
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;

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 4016: FROM igs_sc_usr_attribs attr

4012: SELECT attr.user_attrib_name,
4013: attr.user_attrib_type,
4014: attr.static_type,
4015: attr.select_text
4016: FROM igs_sc_usr_attribs attr
4017: WHERE attr.user_attrib_id = p_user_attrib_id;
4018:
4019: CURSOR c_get_grant_info IS
4020: SELECT cond.grant_id,

Line 4163: UPDATE igs_sc_usr_attribs attr

4159:
4160: -- -----------------------------------------------------------------
4161: -- Update the user attribute values.
4162: -- -----------------------------------------------------------------
4163: UPDATE igs_sc_usr_attribs attr
4164: SET attr.user_attrib_name = l_user_attrib_name,
4165: attr.user_attrib_type = l_user_attrib_type,
4166: attr.static_type = l_static_type,
4167: attr.select_text = l_select_text,

Line 5336: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

5332: ******************************************************************/
5333: PROCEDURE Delete_User_Attr (p_api_version IN NUMBER,
5334: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5335: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5336: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
5337: x_return_status OUT NOCOPY VARCHAR2,
5338: x_return_message OUT NOCOPY VARCHAR2
5339: ) IS
5340:

Line 5454: FROM igs_sc_usr_attribs attr

5450: -- -----------------------------------------------------------------
5451: -- Delete the user attributes associated to the attribute id given
5452: -- -----------------------------------------------------------------
5453: DELETE
5454: FROM igs_sc_usr_attribs attr
5455: WHERE attr.user_attrib_id = p_user_attrib_id;
5456:
5457: -- -----------------------------------------------------------------
5458: -- Commit the transaction if requested to via parameter value.

Line 5535: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,

5531: ******************************************************************/
5532: PROCEDURE Delete_User_Attr_Val (p_api_version IN NUMBER,
5533: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5534: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5535: p_user_attrib_id IN igs_sc_usr_attribs.user_attrib_id%TYPE,
5536: p_user_id IN NUMBER,
5537: x_return_status OUT NOCOPY VARCHAR2,
5538: x_return_message OUT NOCOPY VARCHAR2
5539: ) IS

Line 7124: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE;

7120: -- -----------------------------------------------------------------
7121: -- Define local variables to be used.
7122: -- -----------------------------------------------------------------
7123: l_api_name CONSTANT VARCHAR2(30) := 'Validate_User_Attr_ID';
7124: l_user_attr_id igs_sc_usr_attribs.user_attrib_id%TYPE;
7125:
7126: -- -----------------------------------------------------------------
7127: -- Define the cursors to be used in procedure.
7128: -- -----------------------------------------------------------------

Line 7131: FROM igs_sc_usr_attribs attr

7127: -- Define the cursors to be used in procedure.
7128: -- -----------------------------------------------------------------
7129: CURSOR c_check_user_attr_id IS
7130: SELECT attr.user_attrib_id
7131: FROM igs_sc_usr_attribs attr
7132: WHERE attr.user_attrib_id = p_user_attr_id;
7133:
7134: BEGIN
7135:

Line 7785: IGS_SC_USR_ATTRIBS user_attrib_id

7781:
7782: /* This procedure shifts sequences in all tables to remove empty spaces in numbering
7783: Table list :
7784:
7785: IGS_SC_USR_ATTRIBS user_attrib_id
7786:
7787: IGS_SC_USR_ATT_VALS user_id ,user_attrib_id
7788:
7789: IGS_SC_OBJ_GROUPS obj_group_id

Line 7816: CURSOR igs_sc_usr_attribs_c IS

7812: FROM igs_sc_grants
7813: ORDER BY grant_id
7814: FOR UPDATE OF grant_id;
7815:
7816: CURSOR igs_sc_usr_attribs_c IS
7817: SELECT user_attrib_id
7818: FROM igs_sc_usr_attribs
7819: ORDER BY user_attrib_id
7820: FOR UPDATE OF user_attrib_id;

Line 7818: FROM igs_sc_usr_attribs

7814: FOR UPDATE OF grant_id;
7815:
7816: CURSOR igs_sc_usr_attribs_c IS
7817: SELECT user_attrib_id
7818: FROM igs_sc_usr_attribs
7819: ORDER BY user_attrib_id
7820: FOR UPDATE OF user_attrib_id;
7821:
7822: CURSOR igs_sc_obj_groups_c IS

Line 7881: FOR igs_sc_usr_attribs_rec IN igs_sc_usr_attribs_c LOOP

7877: -- UPDATE USER ATTRIBS
7878:
7879: l_current_seq := 1;
7880:
7881: FOR igs_sc_usr_attribs_rec IN igs_sc_usr_attribs_c LOOP
7882:
7883: IF igs_sc_usr_attribs_rec.user_attrib_id <> l_current_seq THEN
7884:
7885: -- Update all tables

Line 7883: IF igs_sc_usr_attribs_rec.user_attrib_id <> l_current_seq THEN

7879: l_current_seq := 1;
7880:
7881: FOR igs_sc_usr_attribs_rec IN igs_sc_usr_attribs_c LOOP
7882:
7883: IF igs_sc_usr_attribs_rec.user_attrib_id <> l_current_seq THEN
7884:
7885: -- Update all tables
7886:
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;

Line 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;

7883: IF igs_sc_usr_attribs_rec.user_attrib_id <> l_current_seq THEN
7884:
7885: -- Update all tables
7886:
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;

Line 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;

7884:
7885: -- Update all tables
7886:
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:

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;