DBA Data[Home] [Help]

APPS.IEX_TRX_GRID_PVT dependencies on FND_GLOBAL

Line 65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);

61:
62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:

Line 66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);

62: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
63: DBMS_SQL.PARSE(l_cursor_id, l_sql_stmt, 1);
64: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_unpaid_reason', p_unpaid_reason);
65: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_updated_by', FND_GLOBAL.USER_ID);
66: DBMS_SQL.BIND_VARIABLE(l_cursor_id, 'b_last_update_login', FND_GLOBAL.CONC_LOGIN_ID);
67: x_rows_processed := DBMS_SQL.EXECUTE(l_cursor_id);
68: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
69:
70: -- Standard check of p_commit

Line 100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;

96: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
97: END Set_Unpaid_Reason;
98: BEGIN
99: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
103: G_USER_ID := FND_GLOBAL.User_Id;
104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

Line 101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;

97: END Set_Unpaid_Reason;
98: BEGIN
99: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
103: G_USER_ID := FND_GLOBAL.User_Id;
104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
105: END IEX_TRX_GRID_PVT;

Line 102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;

98: BEGIN
99: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
103: G_USER_ID := FND_GLOBAL.User_Id;
104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
105: END IEX_TRX_GRID_PVT;

Line 103: G_USER_ID := FND_GLOBAL.User_Id;

99: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
103: G_USER_ID := FND_GLOBAL.User_Id;
104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
105: END IEX_TRX_GRID_PVT;

Line 104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;

100: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;
101: G_LOGIN_ID := FND_GLOBAL.Conc_Login_Id;
102: G_PROGRAM_ID := FND_GLOBAL.Conc_Program_Id;
103: G_USER_ID := FND_GLOBAL.User_Id;
104: G_REQUEST_ID := FND_GLOBAL.Conc_Request_Id;
105: END IEX_TRX_GRID_PVT;