APPS.INV_SHORTSTATEMENT_PVT dependencies on MTL_SHORT_CHK_STATEMENTS

Line 1620: FROM mtl_short_chk_statements

1616: IS
1617: CURSOR crsStatement ( p_organization_id NUMBER,
1618: p_detail_sum_flag NUMBER ) IS
1619: SELECT 1
1620: FROM mtl_short_chk_statements
1621: WHERE organization_id = p_organization_id
1622: AND detail_sum_flag = p_detail_sum_flag;
1623: --
1624: L_api_version CONSTANT NUMBER := 1.0;

Line 1650: INSERT INTO mtl_short_chk_statements (

1646: OPEN crsStatement ( p_organization_id,
1647: 1 );
1648: FETCH crsStatement INTO L_Object_Exists;
1649: IF crsStatement%NOTFOUND THEN
1650: INSERT INTO mtl_short_chk_statements (
1651: organization_id,
1652: detail_sum_flag,
1653: short_statement,
1654: last_updated_by,

Line 1671: UPDATE mtl_short_chk_statements

1667: FND_GLOBAL.USER_ID,
1668: sysdate
1669: );
1670: ELSE
1671: UPDATE mtl_short_chk_statements
1672: SET short_statement = p_short_stat_detail,
1673: last_update_date = sysdate,
1674: last_updated_by = FND_GLOBAL.USER_ID,
1675: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1685: INSERT INTO mtl_short_chk_statements (

1681: OPEN crsStatement ( p_organization_id,
1682: 2 );
1683: FETCH crsStatement INTO L_Object_Exists;
1684: IF crsStatement%NOTFOUND THEN
1685: INSERT INTO mtl_short_chk_statements (
1686: organization_id,
1687: detail_sum_flag,
1688: short_statement,
1689: last_updated_by,

Line 1706: UPDATE mtl_short_chk_statements

1702: FND_GLOBAL.USER_ID,
1703: sysdate
1704: );
1705: ELSE
1706: UPDATE mtl_short_chk_statements
1707: SET short_statement = p_short_stat_sum,
1708: last_update_date = sysdate,
1709: last_updated_by = FND_GLOBAL.USER_ID,
1710: last_update_login = FND_GLOBAL.LOGIN_ID