462: l_return_status VARCHAR2(30);
463: l_msg_count NUMBER;
464: l_msg_data VARCHAR2(4000);
465:
466: l_user_id NUMBER := FND_GLOBAL.USER_ID;
467: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
468:
469: l_transaction_header_id NUMBER;
470: l_supp_trade_profile_id NUMBER;
463: l_msg_count NUMBER;
464: l_msg_data VARCHAR2(4000);
465:
466: l_user_id NUMBER := FND_GLOBAL.USER_ID;
467: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
468:
469: l_transaction_header_id NUMBER;
470: l_supp_trade_profile_id NUMBER;
471: l_org_id NUMBER;
850: l_api_name constant VARCHAR2(30) := 'update_status';
851: l_api_version constant NUMBER := 1.0;
852: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
853:
854: l_user_id NUMBER := FND_GLOBAL.USER_ID;
855: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
856: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
857: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
858: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
851: l_api_version constant NUMBER := 1.0;
852: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
853:
854: l_user_id NUMBER := FND_GLOBAL.USER_ID;
855: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
856: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
857: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
858: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
859:
852: l_full_name constant VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
853:
854: l_user_id NUMBER := FND_GLOBAL.USER_ID;
855: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
856: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
857: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
858: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
859:
860: l_return_status VARCHAR2(30);
853:
854: l_user_id NUMBER := FND_GLOBAL.USER_ID;
855: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
856: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
857: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
858: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
859:
860: l_return_status VARCHAR2(30);
861: l_msg_count NUMBER;
854: l_user_id NUMBER := FND_GLOBAL.USER_ID;
855: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
856: l_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
857: l_program_application_id NUMBER := FND_GLOBAL.PROG_APPL_ID;
858: l_program_id NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
859:
860: l_return_status VARCHAR2(30);
861: l_msg_count NUMBER;
862: l_msg_data VARCHAR2(4000);