DBA Data[Home] [Help]

APPS.DPP_EXECUTIONPROCESS_PVT dependencies on FND_GLOBAL

Line 1099: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1095: IS
1096: l_api_name CONSTANT VARCHAR2(30) := 'InsertExecProcesses';
1097: l_api_version_number CONSTANT NUMBER := 1.0;
1098:
1099: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1101:
1102: l_exe_process_cnt NUMBER := 0;
1103:

Line 1100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1096: l_api_name CONSTANT VARCHAR2(30) := 'InsertExecProcesses';
1097: l_api_version_number CONSTANT NUMBER := 1.0;
1098:
1099: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1100: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1101:
1102: l_exe_process_cnt NUMBER := 0;
1103:
1104: --Cursor to get the count of execution processes for the transaction

Line 1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1243: l_api_name CONSTANT VARCHAR2(30) := 'Change_Status';
1244: l_api_version CONSTANT NUMBER := 1.0;
1245: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1246:
1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

Line 1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1244: l_api_version CONSTANT NUMBER := 1.0;
1245: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1246:
1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1252:

Line 1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1245: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1246:
1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1252:
1253: l_return_status VARCHAR2(10);

Line 1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1246:
1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1252:
1253: l_return_status VARCHAR2(10);
1254: l_msg_data VARCHAR2(4000);

Line 1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1247: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1248: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1249: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1250: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1251: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1252:
1253: l_return_status VARCHAR2(10);
1254: l_msg_data VARCHAR2(4000);
1255: l_msg_count NUMBER;

Line 1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1608: l_api_name CONSTANT VARCHAR2(30) := 'approve_transaction';
1609: l_api_version_number CONSTANT NUMBER := 1.0;
1610: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1611:
1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

Line 1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

1609: l_api_version_number CONSTANT NUMBER := 1.0;
1610: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1611:
1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1617:

Line 1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

1610: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1611:
1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1617:
1618: l_init_msg_list VARCHAR2(10) := p_init_msg_list;

Line 1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;

1611:
1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1617:
1618: l_init_msg_list VARCHAR2(10) := p_init_msg_list;
1619: l_commit VARCHAR2(10) := p_commit;

Line 1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;

1612: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1613: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1614: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
1615: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
1616: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
1617:
1618: l_init_msg_list VARCHAR2(10) := p_init_msg_list;
1619: l_commit VARCHAR2(10) := p_commit;
1620: l_validation_level NUMBER := p_validation_level;

Line 1777: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1773: l_api_name CONSTANT VARCHAR2(30) := 'update_status';
1774: l_api_version_number CONSTANT NUMBER := 1.0;
1775: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1776:
1777: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1778: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1779:
1780: l_return_status VARCHAR2(10);
1781: l_msg_data VARCHAR2(4000);

Line 1778: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1774: l_api_version_number CONSTANT NUMBER := 1.0;
1775: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1776:
1777: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1778: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1779:
1780: l_return_status VARCHAR2(10);
1781: l_msg_data VARCHAR2(4000);
1782: l_msg_count NUMBER;

Line 1905: l_user_id NUMBER := FND_GLOBAL.USER_ID;

1901: l_api_name CONSTANT VARCHAR2(30) := 'Update_HeaderLog';
1902: l_api_version_number CONSTANT NUMBER := 1.0;
1903: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1904:
1905: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1906: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1907:
1908: l_return_status VARCHAR2(10);
1909: l_msg_data VARCHAR2(4000);

Line 1906: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

1902: l_api_version_number CONSTANT NUMBER := 1.0;
1903: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
1904:
1905: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1906: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1907:
1908: l_return_status VARCHAR2(10);
1909: l_msg_data VARCHAR2(4000);
1910: l_msg_count NUMBER;