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 1821: if AK_CUSTOM_PVT.CUST_REGION_EXISTS (

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

Line 1834: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

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

Line 1898: AK_CUSTOM_PVT.UPDATE_CUST_REGION (

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

Line 1925: AK_CUSTOM_PVT.CREATE_CUST_REGION (

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

Line 1968: if AK_CUSTOM_PVT.CUST_REG_ITEM_EXISTS (

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

Line 1979: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (

1975: p_attribute_appl_id => G_CUST_REG_ITEM_REDO_TBL(l_index).attr_appl_id,
1976: p_attribute_code => G_CUST_REG_ITEM_REDO_TBL(l_index).attr_code,
1977: p_property_name => G_CUST_REG_ITEM_REDO_TBL(l_index).property_name)
1978: then
1979: AK_CUSTOM_PVT.UPDATE_CUST_REG_ITEM (
1980: p_validation_level => p_validation_level,
1981: p_api_version_number => 1.0,
1982: p_msg_count => l_msg_count,
1983: p_msg_data => l_msg_data,

Line 2006: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (

2002: p_pass => p_pass,
2003: p_copy_redo_flag => l_copy_redo_flag
2004: );
2005: else
2006: AK_CUSTOM_PVT.CREATE_CUST_REG_ITEM (
2007: p_validation_level => p_validation_level,
2008: p_api_version_number => 1.0,
2009: p_msg_count => l_msg_count,
2010: p_msg_data => l_msg_data,

Line 2052: if AK_CUSTOM_PVT.CRITERIA_EXISTS (

2048: if (G_CRITERIA_REDO_INDEX > 0) then
2049: for l_index in G_CRITERIA_REDO_TBL.FIRST .. G_CRITERIA_REDO_TBL.LAST
2050: loop
2051: if (G_CRITERIA_REDO_TBL.exists(l_index)) then
2052: if AK_CUSTOM_PVT.CRITERIA_EXISTS (
2053: p_api_version_number => 1.0,
2054: p_return_status => l_return_status,
2055: p_custom_appl_id => G_CRITERIA_REDO_TBL(l_index).customization_application_id,
2056: p_custom_code => G_CRITERIA_REDO_TBL(l_index).customization_code,

Line 2062: AK_CUSTOM_PVT.UPDATE_CRITERIA (

2058: p_region_code => G_CRITERIA_REDO_TBL(l_index).region_code,
2059: p_attribute_appl_id => G_CRITERIA_REDO_TBL(l_index).attribute_application_id,
2060: p_attribute_code => G_CRITERIA_REDO_TBL(l_index).attribute_code,
2061: p_sequence_number => G_CRITERIA_REDO_TBL(l_index).sequence_number) then
2062: AK_CUSTOM_PVT.UPDATE_CRITERIA (
2063: p_validation_level => p_validation_level,
2064: p_api_version_number => 1.0,
2065: p_msg_count => l_msg_count,
2066: p_msg_data => l_msg_data,

Line 2091: AK_CUSTOM_PVT.CREATE_CRITERIA (

2087: p_pass => p_pass,
2088: p_copy_redo_flag => l_copy_redo_flag
2089: );
2090: else
2091: AK_CUSTOM_PVT.CREATE_CRITERIA (
2092: p_validation_level => p_validation_level,
2093: p_api_version_number => 1.0,
2094: p_msg_count => l_msg_count,
2095: p_msg_data => l_msg_data,