DBA Data[Home] [Help]

APPS.AK_CUSTOM_PVT dependencies on AK_ON_OBJECTS_PUB

Line 777: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

773: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
774: and CUSTOMIZATION_CODE = p_custom_code
775: and LANGUAGE = p_nls_language;
776: l_api_name CONSTANT varchar2(30) := 'Write_Custom_to_buffer';
777: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
778: l_index NUMBER;
779: l_custom_rec AK_CUSTOMIZATIONS%ROWTYPE;
780: l_custom_tl_rec AK_CUSTOMIZATIONS_TL%ROWTYPE;
781: l_return_status varchar2(1);

Line 942: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

938: (l_custom_rec.start_date_active <> FND_API.G_MISS_DATE)) then
939: l_index := l_index + 1;
940: l_databuffer_tbl(l_index) := ' START_DATE_ACTIVE = "' ||
941: to_char(l_custom_rec.start_date_active,
942: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
943: end if;
944: if ((l_custom_rec.end_date_active IS NOT NULL) and
945: (l_custom_rec.end_date_active <> FND_API.G_MISS_DATE)) then
946: l_index := l_index + 1;

Line 949: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

945: (l_custom_rec.end_date_active <> FND_API.G_MISS_DATE)) then
946: l_index := l_index + 1;
947: l_databuffer_tbl(l_index) := ' END_DATE_ACTIVE = "' ||
948: to_char(l_custom_rec.end_date_active,
949: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
950: end if;
951: -- - Write out who columns
952: l_index := l_index + 1;
953: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||

Line 958: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

954: nvl(to_char(l_custom_rec.created_by),'') || '"';
955: l_index := l_index + 1;
956: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
957: to_char(l_custom_rec.creation_date,
958: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
959: l_index := l_index + 1;
960: -- CHANGED TO OWNER FOR R12
961: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
962: -- nvl(to_char(l_custom_rec.last_updated_by),'') || '"';A

Line 968: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

964: FND_LOAD_UTIL.OWNER_NAME(l_custom_rec.last_updated_by) || '"';
965: l_index := l_index + 1;
966: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
967: to_char(l_custom_rec.last_update_date,
968: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
969: l_index := l_index + 1;
970: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
971: nvl(to_char(l_custom_rec.last_update_login),'') || '"';
972:

Line 992: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

988: -- - Write the custom data to the specified file
989: AK_ON_OBJECTS_PVT.WRITE_FILE (
990: p_return_status => l_return_status,
991: p_buffer_tbl => l_databuffer_tbl,
992: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
993: );
994: -- If API call returns with an error status...
995: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
996: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1062: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1058: -- - Write the 'END CUSTOMIZATION' to the specified file
1059: AK_ON_OBJECTS_PVT.WRITE_FILE (
1060: p_return_status => l_return_status,
1061: p_buffer_tbl => l_databuffer_tbl,
1062: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1063: );
1064: -- If API call returns with an error status...
1065: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1066: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1152: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1148: and CUSTOMIZATION_CODE = p_custom_code
1149: and PROPERTY_NAME = property_name_param
1150: and LANGUAGE = p_nls_language;
1151: l_api_name CONSTANT varchar2(30) := 'Write_Cust_Region_to_buffer';
1152: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1153: l_index NUMBER;
1154: l_cust_region_rec AK_CUSTOM_REGIONS%ROWTYPE;
1155: l_cust_region_tl_rec AK_CUSTOM_REGIONS_TL%ROWTYPE;
1156: l_return_status varchar2(1);

Line 1238: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1234: nvl(to_char(l_cust_region_rec.created_by),'') || '"';
1235: l_index := l_index + 1;
1236: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1237: to_char(l_cust_region_rec.creation_date,
1238: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1239: l_index := l_index + 1;
1240: -- CHANGED TO OWNER FOR R12
1241: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1242: -- nvl(to_char(l_cust_region_rec.last_updated_by),'') || '"';

Line 1248: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1244: FND_LOAD_UTIL.OWNER_NAME(l_cust_region_rec.last_updated_by) || '"';
1245: l_index := l_index + 1;
1246: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1247: to_char(l_cust_region_rec.last_update_date,
1248: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1249: l_index := l_index + 1;
1250: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1251: nvl(to_char(l_cust_region_rec.last_update_login),'') || '"';
1252: -- translation columns

Line 1271: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1267: -- - Write the custom region data to the specified file
1268: AK_ON_OBJECTS_PVT.WRITE_FILE (
1269: p_return_status => l_return_status,
1270: p_buffer_tbl => l_databuffer_tbl,
1271: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1272: );
1273: -- If API call returns with an error status...
1274: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1275: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1368: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1364: and ATTRIBUTE_CODE = param_attr_code
1365: and PROPERTY_NAME = param_property_name
1366: and LANGUAGE = p_nls_language;
1367: l_api_name CONSTANT varchar2(30) := 'Write_Cust_Reg_Item_to_buffer';
1368: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1369: l_index NUMBER;
1370: l_cust_region_item_rec AK_CUSTOM_REGION_ITEMS%ROWTYPE;
1371: l_cust_region_item_tl_rec AK_CUSTOM_REGION_ITEMS_TL%ROWTYPE;
1372: l_return_status varchar2(1);

Line 1451: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1447: (l_cust_region_item_rec.property_date_value <> FND_API.G_MISS_DATE)) then
1448: l_index := l_index + 1;
1449: l_databuffer_tbl(l_index) := ' PROPERTY_DATE_VALUE = "' ||
1450: to_char(l_cust_region_item_rec.property_date_value,
1451: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1452: end if;
1453: -- - Write out who columns
1454: l_index := l_index + 1;
1455: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||

Line 1460: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1456: nvl(to_char(l_cust_region_item_rec.created_by),'') || '"';
1457: l_index := l_index + 1;
1458: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1459: to_char(l_cust_region_item_rec.creation_date,
1460: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1461: l_index := l_index + 1;
1462: -- CHANGED TO OWNER FOR R12
1463: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1464: -- nvl(to_char(l_cust_region_item_rec.last_updated_by),'') || '"';

Line 1470: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1466: FND_LOAD_UTIL.OWNER_NAME(l_cust_region_item_rec.last_updated_by) || '"';
1467: l_index := l_index + 1;
1468: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1469: to_char(l_cust_region_item_rec.last_update_date,
1470: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1471: l_index := l_index + 1;
1472: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1473: nvl(to_char(l_cust_region_item_rec.last_update_login),'') || '"';
1474:

Line 1494: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1490: -- - Write the custom region item data to the specified file
1491: AK_ON_OBJECTS_PVT.WRITE_FILE (
1492: p_return_status => l_return_status,
1493: p_buffer_tbl => l_databuffer_tbl,
1494: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1495: );
1496: -- If API call returns with an error status...
1497: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1498: (l_return_status = FND_API.G_RET_STS_ERROR) then

Line 1578: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;

1574: and REGION_CODE = p_region_code
1575: and CUSTOMIZATION_APPLICATION_ID = p_custom_application_id
1576: and CUSTOMIZATION_CODE = p_custom_code;
1577: l_api_name CONSTANT varchar2(30) := 'Write_Criteria_to_buffer';
1578: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1579: l_index NUMBER;
1580: l_criteria_rec AK_CRITERIA%ROWTYPE;
1581: l_return_status varchar2(1);
1582: begin

Line 1647: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1643: (l_criteria_rec.value_date <> FND_API.G_MISS_DATE)) then
1644: l_index := l_index + 1;
1645: l_databuffer_tbl(l_index) := ' VALUE_DATE = "' ||
1646: to_char(l_criteria_rec.value_date,
1647: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1648: end if;
1649: if ((l_criteria_rec.start_date_active IS NOT NULL) and
1650: (l_criteria_rec.start_date_Active <> FND_API.G_MISS_DATE)) then
1651: l_index := l_index + 1;

Line 1654: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1650: (l_criteria_rec.start_date_Active <> FND_API.G_MISS_DATE)) then
1651: l_index := l_index + 1;
1652: l_databuffer_tbl(l_index) := ' START_DATE_ACTIVE = "' ||
1653: to_char(l_criteria_rec.start_date_active,
1654: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1655: end if;
1656: if ((l_criteria_rec.end_date_active IS NOT NULL) and
1657: (l_criteria_rec.end_date_Active <> FND_API.G_MISS_DATE)) then
1658: l_index := l_index + 1;

Line 1661: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1657: (l_criteria_rec.end_date_Active <> FND_API.G_MISS_DATE)) then
1658: l_index := l_index + 1;
1659: l_databuffer_tbl(l_index) := ' END_DATE_ACTIVE = "' ||
1660: to_char(l_criteria_rec.end_date_active,
1661: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1662: end if;
1663: -- - Write out who columns
1664: l_index := l_index + 1;
1665: l_databuffer_tbl(l_index) := ' CREATED_BY = "' ||

Line 1670: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1666: nvl(to_char(l_criteria_rec.created_by),'') || '"';
1667: l_index := l_index + 1;
1668: l_databuffer_tbl(l_index) := ' CREATION_DATE = "' ||
1669: to_char(l_criteria_rec.creation_date,
1670: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1671: l_index := l_index + 1;
1672: -- CHANGED TO OWNER FOR R12
1673: -- l_databuffer_tbl(l_index) := ' LAST_UPDATED_BY = "' ||
1674: -- nvl(to_char(l_criteria_rec.last_updated_by),'') || '"';

Line 1680: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';

1676: FND_LOAD_UTIL.OWNER_NAME(l_criteria_rec.last_updated_by) || '"';
1677: l_index := l_index + 1;
1678: l_databuffer_tbl(l_index) := ' LAST_UPDATE_DATE = "' ||
1679: to_char(l_criteria_rec.last_update_date,
1680: AK_ON_OBJECTS_PUB.G_DATE_FORMAT) || '"';
1681: l_index := l_index + 1;
1682: l_databuffer_tbl(l_index) := ' LAST_UPDATE_LOGIN = "' ||
1683: nvl(to_char(l_criteria_rec.last_update_login),'') || '"';
1684:

Line 1697: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND

1693: -- - Write the custom criteria to the specified file
1694: AK_ON_OBJECTS_PVT.WRITE_FILE (
1695: p_return_status => l_return_status,
1696: p_buffer_tbl => l_databuffer_tbl,
1697: p_write_mode => AK_ON_OBJECTS_PUB.G_APPEND
1698: );
1699: -- If API call returns with an error status...
1700: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
1701: (l_return_status = FND_API.G_RET_STS_ERROR) then