1460: OPEN get_po_catset;
1461: FETCH get_po_catset INTO l_po_category_set;
1462: CLOSE get_po_catset;
1463:
1464: l_user_id := FND_GLOBAL.USER_ID;
1465: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1466: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1467: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1468:
1461: FETCH get_po_catset INTO l_po_category_set;
1462: CLOSE get_po_catset;
1463:
1464: l_user_id := FND_GLOBAL.USER_ID;
1465: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1466: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1467: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1468:
1469: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1462: CLOSE get_po_catset;
1463:
1464: l_user_id := FND_GLOBAL.USER_ID;
1465: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1466: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1467: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1468:
1469: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1470: FND_MSG_PUB.Initialize ;
1463:
1464: l_user_id := FND_GLOBAL.USER_ID;
1465: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1466: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1467: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1468:
1469: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1470: FND_MSG_PUB.Initialize ;
1471: END IF;
1887: l_vbh_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1888: OPEN get_po_catset;
1889: FETCH get_po_catset INTO l_po_category_set_id;
1890: CLOSE get_po_catset;
1891: l_user_id := FND_GLOBAL.USER_ID;
1892: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1893: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1894: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1895: l_process_flag := 7;
1888: OPEN get_po_catset;
1889: FETCH get_po_catset INTO l_po_category_set_id;
1890: CLOSE get_po_catset;
1891: l_user_id := FND_GLOBAL.USER_ID;
1892: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1893: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1894: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1895: l_process_flag := 7;
1896:
1889: FETCH get_po_catset INTO l_po_category_set_id;
1890: CLOSE get_po_catset;
1891: l_user_id := FND_GLOBAL.USER_ID;
1892: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1893: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1894: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1895: l_process_flag := 7;
1896:
1897: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1890: CLOSE get_po_catset;
1891: l_user_id := FND_GLOBAL.USER_ID;
1892: l_conc_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1893: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
1894: l_conc_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1895: l_process_flag := 7;
1896:
1897: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1898: FND_MSG_PUB.Initialize ;