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:
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
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;
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:
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);
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);
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;
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;
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:
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;
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;
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;
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);
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;
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);
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;