806: p_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: -- API body
809: l_last_update_date := SYSDATE;
810: l_last_updated_by := FND_GLOBAL.USER_ID;
811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
812: l_creation_date := SYSDATE;
813: l_created_by := FND_GLOBAL.USER_ID;
814:
807:
808: -- API body
809: l_last_update_date := SYSDATE;
810: l_last_updated_by := FND_GLOBAL.USER_ID;
811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
812: l_creation_date := SYSDATE;
813: l_created_by := FND_GLOBAL.USER_ID;
814:
815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
809: l_last_update_date := SYSDATE;
810: l_last_updated_by := FND_GLOBAL.USER_ID;
811: l_last_update_login := FND_GLOBAL.LOGIN_ID;
812: l_creation_date := SYSDATE;
813: l_created_by := FND_GLOBAL.USER_ID;
814:
815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: RAISE FND_API.G_EXC_ERROR;
817: END IF;
1861: p_return_status := FND_API.G_RET_STS_SUCCESS;
1862:
1863: -- API body
1864: l_last_update_date := SYSDATE;
1865: l_last_updated_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867: l_creation_date := SYSDATE;
1868: l_created_by := FND_GLOBAL.USER_ID;
1869:
1862:
1863: -- API body
1864: l_last_update_date := SYSDATE;
1865: l_last_updated_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867: l_creation_date := SYSDATE;
1868: l_created_by := FND_GLOBAL.USER_ID;
1869:
1870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1864: l_last_update_date := SYSDATE;
1865: l_last_updated_by := FND_GLOBAL.USER_ID;
1866: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1867: l_creation_date := SYSDATE;
1868: l_created_by := FND_GLOBAL.USER_ID;
1869:
1870: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;