DBA Data[Home] [Help]

APPS.AK_CUSTOM2_PVT dependencies on AK_CUSTOM_PVT

Line 977: if AK_CUSTOM_PVT.CUSTOM_EXISTS (

973: --
974: if (l_custom_tbl.count > 0) then
975: for l_index in l_custom_tbl.FIRST .. l_custom_tbl.LAST loop
976: if (l_custom_tbl.exists(l_index)) then
977: if AK_CUSTOM_PVT.CUSTOM_EXISTS (
978: p_api_version_number => 1.0,
979: p_return_status => l_return_status,
980: p_custom_appl_id => l_custom_tbl(l_index).customization_appl_id,
981: p_custom_code => l_custom_tbl(l_index).customization_code,

Line 988: AK_CUSTOM_PVT.UPDATE_CUSTOM (

984: --
985: -- Update Regions only if G_UPDATE_MODE is TRUE
986: --
987: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
988: AK_CUSTOM_PVT.UPDATE_CUSTOM (
989: p_validation_level => p_validation_level,
990: p_api_version_number => 1.0,
991: p_msg_count => l_msg_count,
992: p_msg_data => l_msg_data,

Line 1065: AK_CUSTOM_PVT.UPDATE_CUSTOM (

1061: p_db_last_update_date => l_update2,
1062: p_last_update_login => l_custom_tbl(l_index).last_update_login,
1063: p_create_or_update => 'UPDATE')) then
1064:
1065: AK_CUSTOM_PVT.UPDATE_CUSTOM (
1066: p_validation_level => p_validation_level,
1067: p_api_version_number => 1.0,
1068: p_msg_count => l_msg_count,
1069: p_msg_data => l_msg_data,

Line 1102: AK_CUSTOM_PVT.CREATE_CUSTOM (

1098: );
1099: end if; -- /* if ( l_user_id1 = 1 and l_user_id1 = 1 ) */
1100: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1101: else
1102: AK_CUSTOM_PVT.CREATE_CUSTOM (
1103: p_validation_level => p_validation_level,
1104: p_api_version_number => 1.0,
1105: p_msg_count => l_msg_count,
1106: p_msg_data => l_msg_data,

Line 1160: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (

1156: --
1157: if (l_cust_region_tbl.count > 0) then
1158: for l_index in l_cust_region_tbl.FIRST .. l_cust_region_tbl.LAST loop
1159: if (l_cust_region_tbl.exists(l_index)) then
1160: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (
1161: p_api_version_number => 1.0,
1162: p_return_status => l_return_status,
1163: p_custom_appl_id => l_cust_region_tbl(l_index).customization_appl_id,
1164: p_custom_code => l_cust_region_tbl(l_index).customization_code,

Line 1173: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

1169: --
1170: -- Update Regions only if G_UPDATE_MODE is TRUE
1171: --
1172: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
1173: AK_CUSTOM_PVT.UPDATE_CUST_REGION (
1174: p_validation_level => p_validation_level,
1175: p_api_version_number => 1.0,
1176: p_msg_count => l_msg_count,
1177: p_msg_data => l_msg_data,

Line 1244: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

1240: p_db_last_update_date => l_update2,
1241: p_last_update_login => l_cust_region_tbl(l_index).last_update_login,
1242: p_create_or_update => 'UPDATE')) then
1243:
1244: AK_CUSTOM_PVT.UPDATE_CUST_REGION (
1245: p_validation_level => p_validation_level,
1246: p_api_version_number => 1.0,
1247: p_msg_count => l_msg_count,
1248: p_msg_data => l_msg_data,

Line 1271: AK_CUSTOM_PVT.CREATE_CUST_REGION (

1267: );
1268: end if; -- /* if ( l_user_id1 = 1 and l_user_id2 = 1 ) */
1269: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1270: else
1271: AK_CUSTOM_PVT.CREATE_CUST_REGION (
1272: p_validation_level => p_validation_level,
1273: p_api_version_number => 1.0,
1274: p_msg_count => l_msg_count,
1275: p_msg_data => l_msg_data,

Line 1319: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (

1315: --
1316: if (l_cust_reg_item_tbl.count > 0) then
1317: for l_index in l_cust_reg_item_tbl.FIRST .. l_cust_reg_item_tbl.LAST loop
1318: if (l_cust_reg_item_tbl.exists(l_index)) then
1319: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (
1320: p_api_version_number => 1.0,
1321: p_return_status => l_return_status,
1322: p_custom_appl_id => l_cust_reg_item_tbl(l_index).customization_appl_id,
1323: p_custom_code => l_cust_reg_item_tbl(l_index).customization_code,

Line 1333: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (

1329: --
1330: -- Update Regions only if G_UPDATE_MODE is TRUE
1331: --
1332: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
1333: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (
1334: p_validation_level => p_validation_level,
1335: p_api_version_number => 1.0,
1336: p_msg_count => l_msg_count,
1337: p_msg_data => l_msg_data,

Line 1412: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (

1408: p_db_last_update_date => l_update2,
1409: p_last_update_login => l_cust_reg_item_tbl(l_index).last_update_login,
1410: p_create_or_update => 'UPDATE')) then
1411:
1412: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (
1413: p_validation_level => p_validation_level,
1414: p_api_version_number => 1.0,
1415: p_msg_count => l_msg_count,
1416: p_msg_data => l_msg_data,

Line 1441: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (

1437: );
1438: end if; -- /* if ( l_user_id1 = 1 and l_user_id2 = 1 ) */
1439: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1440: else
1441: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (
1442: p_validation_level => p_validation_level,
1443: p_api_version_number => 1.0,
1444: p_msg_count => l_msg_count,
1445: p_msg_data => l_msg_data,

Line 1491: if AK_CUSTOM_PVT.CRITERIA_EXISTS (

1487: --
1488: if (l_criteria_tbl.count > 0) then
1489: for l_index in l_criteria_tbl.FIRST .. l_criteria_tbl.LAST loop
1490: if (l_criteria_tbl.exists(l_index)) then
1491: if AK_CUSTOM_PVT.CRITERIA_EXISTS (
1492: p_api_version_number => 1.0,
1493: p_return_status => l_return_status,
1494: p_custom_appl_id => l_criteria_tbl(l_index).customization_application_id,
1495: p_custom_code => l_criteria_tbl(l_index).customization_code,

Line 1505: AK_CUSTOM_PVT.UPDATE_CRITERIA (

1501: --
1502: -- Update Regions only if G_UPDATE_MODE is TRUE
1503: --
1504: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
1505: AK_CUSTOM_PVT.UPDATE_CRITERIA (
1506: p_validation_level => p_validation_level,
1507: p_api_version_number => 1.0,
1508: p_msg_count => l_msg_count,
1509: p_msg_data => l_msg_data,

Line 1564: AK_CUSTOM_PVT.UPDATE_CRITERIA (

1560: p_db_last_update_date => l_update1,
1561: p_last_update_login => l_criteria_tbl(l_index).last_update_login,
1562: p_create_or_update => 'UPDATE') then
1563:
1564: AK_CUSTOM_PVT.UPDATE_CRITERIA (
1565: p_validation_level => p_validation_level,
1566: p_api_version_number => 1.0,
1567: p_msg_count => l_msg_count,
1568: p_msg_data => l_msg_data,

Line 1595: AK_CUSTOM_PVT.CREATE_CRITERIA (

1591: );
1592: end if; -- /* if ( l_user_id1 = 1 and l_user_id2 = 1 ) */
1593: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1594: else
1595: AK_CUSTOM_PVT.CREATE_CRITERIA (
1596: p_validation_level => p_validation_level,
1597: p_api_version_number => 1.0,
1598: p_msg_count => l_msg_count,
1599: p_msg_data => l_msg_data,

Line 1725: if AK_CUSTOM_PVT.CUSTOM_EXISTS (

1721: --
1722: if (G_CUSTOM_REDO_INDEX > 0) then
1723: for l_index in G_CUSTOM_REDO_TBL.FIRST .. G_CUSTOM_REDO_TBL.LAST loop
1724: if (G_CUSTOM_REDO_TBL.exists(l_index)) then
1725: if AK_CUSTOM_PVT.CUSTOM_EXISTS (
1726: p_api_version_number => 1.0,
1727: p_return_status => l_return_status,
1728: p_custom_appl_id => G_CUSTOM_REDO_TBL(l_index).customization_appl_id,
1729: p_custom_code => G_CUSTOM_REDO_TBL(l_index).customization_code,

Line 1733: AK_CUSTOM_PVT.UPDATE_CUSTOM (

1729: p_custom_code => G_CUSTOM_REDO_TBL(l_index).customization_code,
1730: p_region_application_id =>
1731: G_CUSTOM_REDO_TBL(l_index).region_appl_id,
1732: p_region_code => G_CUSTOM_REDO_TBL(l_index).region_code) then
1733: AK_CUSTOM_PVT.UPDATE_CUSTOM (
1734: p_validation_level => p_validation_level,
1735: p_api_version_number => 1.0,
1736: p_msg_count => l_msg_count,
1737: p_msg_data => l_msg_data,

Line 1768: AK_CUSTOM_PVT.CREATE_CUSTOM (

1764: p_pass => p_pass,
1765: p_copy_redo_flag => l_copy_redo_flag
1766: );
1767: else
1768: AK_CUSTOM_PVT.CREATE_CUSTOM (
1769: p_validation_level => p_validation_level,
1770: p_api_version_number => 1.0,
1771: p_msg_count => l_msg_count,
1772: p_msg_data => l_msg_data,

Line 1819: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (

1815: --
1816: if (G_CUST_REGION_REDO_INDEX > 0) then
1817: for l_index in G_CUST_REGION_REDO_TBL.FIRST .. G_CUST_REGION_REDO_TBL.LAST loop
1818: if (G_CUST_REGION_REDO_TBL.exists(l_index)) then
1819: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (
1820: p_api_version_number => 1.0,
1821: p_return_status => l_return_status,
1822: p_custom_appl_id => G_CUST_REGION_REDO_TBL(l_index).customization_appl_id,
1823: p_custom_code => G_CUST_REGION_REDO_TBL(l_index).customization_code,

Line 1832: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

1828: --
1829: -- Update Custom Regions only if G_UPDATE_MODE is TRUE
1830: --
1831: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
1832: AK_CUSTOM_PVT.UPDATE_CUST_REGION (
1833: p_validation_level => p_validation_level,
1834: p_api_version_number => 1.0,
1835: p_msg_count => l_msg_count,
1836: p_msg_data => l_msg_data,

Line 1896: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

1892: p_db_last_update_date => l_update2,
1893: p_last_update_login => G_CUST_REGION_REDO_TBL(l_index).last_update_login,
1894: p_create_or_update => 'UPDATE')) then
1895:
1896: AK_CUSTOM_PVT.UPDATE_CUST_REGION (
1897: p_validation_level => p_validation_level,
1898: p_api_version_number => 1.0,
1899: p_msg_count => l_msg_count,
1900: p_msg_data => l_msg_data,

Line 1923: AK_CUSTOM_PVT.CREATE_CUST_REGION (

1919: );
1920: end if; -- /* if ( l_user_id1 = 1 and l_user_id2 = 1 ) */
1921: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
1922: else
1923: AK_CUSTOM_PVT.CREATE_CUST_REGION (
1924: p_validation_level => p_validation_level,
1925: p_api_version_number => 1.0,
1926: p_msg_count => l_msg_count,
1927: p_msg_data => l_msg_data,

Line 1964: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (

1960: if (G_CUST_REG_ITEM_REDO_INDEX > 0) then
1961: for l_index in G_CUST_REG_ITEM_REDO_TBL.FIRST .. G_CUST_REG_ITEM_REDO_TBL.LAST
1962: loop
1963: if (G_CUST_REG_ITEM_REDO_TBL.exists(l_index)) then
1964: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (
1965: p_api_version_number => 1.0,
1966: p_return_status => l_return_status,
1967: p_custom_appl_id => G_CUST_REG_ITEM_REDO_TBL(l_index).customization_appl_id,
1968: p_custom_code => G_CUST_REG_ITEM_REDO_TBL(l_index).customization_code,

Line 1975: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (

1971: p_attribute_appl_id => G_CUST_REG_ITEM_REDO_TBL(l_index).attr_appl_id,
1972: p_attribute_code => G_CUST_REG_ITEM_REDO_TBL(l_index).attr_code,
1973: p_property_name => G_CUST_REG_ITEM_REDO_TBL(l_index).property_name)
1974: then
1975: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (
1976: p_validation_level => p_validation_level,
1977: p_api_version_number => 1.0,
1978: p_msg_count => l_msg_count,
1979: p_msg_data => l_msg_data,

Line 2002: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (

1998: p_pass => p_pass,
1999: p_copy_redo_flag => l_copy_redo_flag
2000: );
2001: else
2002: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (
2003: p_validation_level => p_validation_level,
2004: p_api_version_number => 1.0,
2005: p_msg_count => l_msg_count,
2006: p_msg_data => l_msg_data,

Line 2046: if AK_CUSTOM_PVT.CRITERIA_EXISTS (

2042: if (G_CRITERIA_REDO_INDEX > 0) then
2043: for l_index in G_CRITERIA_REDO_TBL.FIRST .. G_CRITERIA_REDO_TBL.LAST
2044: loop
2045: if (G_CRITERIA_REDO_TBL.exists(l_index)) then
2046: if AK_CUSTOM_PVT.CRITERIA_EXISTS (
2047: p_api_version_number => 1.0,
2048: p_return_status => l_return_status,
2049: p_custom_appl_id => G_CRITERIA_REDO_TBL(l_index).customization_application_id,
2050: p_custom_code => G_CRITERIA_REDO_TBL(l_index).customization_code,

Line 2056: AK_CUSTOM_PVT.UPDATE_CRITERIA (

2052: p_region_code => G_CRITERIA_REDO_TBL(l_index).region_code,
2053: p_attribute_appl_id => G_CRITERIA_REDO_TBL(l_index).attribute_application_id,
2054: p_attribute_code => G_CRITERIA_REDO_TBL(l_index).attribute_code,
2055: p_sequence_number => G_CRITERIA_REDO_TBL(l_index).sequence_number) then
2056: AK_CUSTOM_PVT.UPDATE_CRITERIA (
2057: p_validation_level => p_validation_level,
2058: p_api_version_number => 1.0,
2059: p_msg_count => l_msg_count,
2060: p_msg_data => l_msg_data,

Line 2085: AK_CUSTOM_PVT.CREATE_CRITERIA (

2081: p_pass => p_pass,
2082: p_copy_redo_flag => l_copy_redo_flag
2083: );
2084: else
2085: AK_CUSTOM_PVT.CREATE_CRITERIA (
2086: p_validation_level => p_validation_level,
2087: p_api_version_number => 1.0,
2088: p_msg_count => l_msg_count,
2089: p_msg_data => l_msg_data,