eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_CUSTOM2_PVT dependencies on AK_ON_OBJECTS_PVT

Line 136: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

132: else
133: l_line_num := p_line_num;
134: end if;
135:
136: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
137: AK_ON_OBJECTS_PVT.READ_LINE (
138: p_return_status => l_return_status,
139: p_index => p_index,
140: p_buffer => l_buffer,

Line 137: AK_ON_OBJECTS_PVT.READ_LINE (

133: l_line_num := p_line_num;
134: end if;
135:
136: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
137: AK_ON_OBJECTS_PVT.READ_LINE (
138: p_return_status => l_return_status,
139: p_index => p_index,
140: p_buffer => l_buffer,
141: p_lines_read => l_lines_read,

Line 175: AK_ON_OBJECTS_PVT.GET_TOKEN(

171:
172: while (l_eof_flag = 'N') and (l_buffer is not null)
173: and (l_more_custom) loop
174:
175: AK_ON_OBJECTS_PVT.GET_TOKEN(
176: p_return_status => l_return_status,
177: p_in_buf => l_buffer,
178: p_token => l_token
179: );

Line 218: -- (ak_on_objects_pvt.upload).

214: l_state := 2;
215: else
216: -- Found the beginning of a non-custom object,
217: -- rebuild last line and pass it back to the caller
218: -- (ak_on_objects_pvt.upload).
219: p_buffer_out := 'BEGIN ' || l_token || ' ' || l_buffer;
220: l_more_custom := FALSE;
221: end if;
222: elsif (l_state = 2) then

Line 931: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop

927: l_buffer := LTRIM(l_buffer);
928:
929: -- Get the next non-blank, non-comment line if current line is
930: -- fully parsed
931: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
932: AK_ON_OBJECTS_PVT.READ_LINE (
933: p_return_status => l_return_status,
934: p_index => p_index,
935: p_buffer => l_buffer,

Line 932: AK_ON_OBJECTS_PVT.READ_LINE (

928:
929: -- Get the next non-blank, non-comment line if current line is
930: -- fully parsed
931: while (l_buffer is null and l_eof_flag = 'N' and p_index <= AK_ON_OBJECTS_PVT.G_UPL_TABLE_NUM) loop
932: AK_ON_OBJECTS_PVT.READ_LINE (
933: p_return_status => l_return_status,
934: p_index => p_index,
935: p_buffer => l_buffer,
936: p_lines_read => l_lines_read,

Line 1043: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1039: and ac.region_code = act.region_code
1040: and act.language = userenv('LANG');
1041: /*if (( l_user_id1 = 1 or l_user_id1 = 2) and
1042: (l_user_id2 = 1 or l_user_id2 = 2)) then*/
1043: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1044: p_loader_timestamp => p_loader_timestamp,
1045: p_created_by => l_custom_tbl(l_index).created_by,
1046: p_creation_date => l_custom_tbl(l_index).creation_date,
1047: p_last_updated_by => l_custom_tbl(l_index).last_updated_by,

Line 1054: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1050: p_db_last_update_date => l_update1,
1051: p_last_update_login => l_custom_tbl(l_index).last_update_login,
1052: p_create_or_update => 'UPDATE') and
1053:
1054: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1055: p_loader_timestamp => p_loader_timestamp,
1056: p_created_by => l_custom_tbl(l_index).created_by,
1057: p_creation_date => l_custom_tbl(l_index).creation_date,
1058: p_last_updated_by => l_custom_tbl(l_index).last_updated_by,

Line 1222: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1218: and ac.property_name = act.property_name
1219: and act.language = userenv('LANG');
1220: /*if (( l_user_id1 = 1 or l_user_id1 = 2)
1221: and (l_user_id2 = 1 or l_user_id2 = 2)) then*/
1222: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1223: p_loader_timestamp => p_loader_timestamp,
1224: p_created_by => l_cust_region_tbl(l_index).created_by,
1225: p_creation_date => l_cust_region_tbl(l_index).creation_date,
1226: p_last_updated_by => l_cust_region_tbl(l_index).last_updated_by,

Line 1233: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1229: p_db_last_update_date => l_update1,
1230: p_last_update_login => l_cust_region_tbl(l_index).last_update_login,
1231: p_create_or_update => 'UPDATE') and
1232:
1233: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1234: p_loader_timestamp => p_loader_timestamp,
1235: p_created_by => l_cust_region_tbl(l_index).created_by,
1236: p_creation_date => l_cust_region_tbl(l_index).creation_date,
1237: p_last_updated_by => l_cust_region_tbl(l_index).last_updated_by,

Line 1390: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1386: and ac.attribute_code = act.attribute_code
1387: and act.language = userenv('LANG');
1388: /*if (( l_user_id1 = 1 or l_user_id1 = 2) and
1389: (l_user_id2 = 1 or l_user_id2 = 2 )) then*/
1390: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1391: p_loader_timestamp => p_loader_timestamp,
1392: p_created_by => l_cust_reg_item_tbl(l_index).created_by,
1393: p_creation_date => l_cust_reg_item_tbl(l_index).creation_date,
1394: p_last_updated_by => l_cust_reg_item_tbl(l_index).last_updated_by,

Line 1401: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1397: p_db_last_update_date => l_update1,
1398: p_last_update_login => l_cust_reg_item_tbl(l_index).last_update_login,
1399: p_create_or_update => 'UPDATE') and
1400:
1401: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1402: p_loader_timestamp => p_loader_timestamp,
1403: p_created_by => l_cust_reg_item_tbl(l_index).created_by,
1404: p_creation_date => l_cust_reg_item_tbl(l_index).creation_date,
1405: p_last_updated_by => l_cust_reg_item_tbl(l_index).last_updated_by,

Line 1553: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1549: and ac.sequence_number = l_criteria_tbl(l_index).sequence_number
1550: and ac.attribute_application_id = l_criteria_tbl(l_index).attribute_application_id
1551: and ac.attribute_code = l_criteria_tbl(l_index).attribute_code;
1552: /*if ( l_user_id1 = 1 or l_user_id1 = 2 ) then*/
1553: if AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1554: p_loader_timestamp => p_loader_timestamp,
1555: p_created_by => l_criteria_tbl(l_index).created_by,
1556: p_creation_date => l_criteria_tbl(l_index).creation_date,
1557: p_last_updated_by => l_criteria_tbl(l_index).last_updated_by,

Line 1874: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1870: and ac.region_code = act.region_code
1871: and act.language = userenv('LANG');
1872: /*if (( l_user_id1 = 1 or l_user_id1 = 2 ) and
1873: ( l_user_id2 = 1 or l_user_id2 = 2 )) then*/
1874: if (AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1875: p_loader_timestamp => p_loader_timestamp,
1876: p_created_by => G_CUST_REGION_REDO_TBL(l_index).created_by,
1877: p_creation_date => G_CUST_REGION_REDO_TBL(l_index).creation_date,
1878: p_last_updated_by => G_CUST_REGION_REDO_TBL(l_index).last_updated_by,

Line 1885: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(

1881: p_db_last_update_date => l_update1,
1882: p_last_update_login => G_CUST_REGION_REDO_TBL(l_index).last_update_login,
1883: p_create_or_update => 'UPDATE') and
1884:
1885: AK_ON_OBJECTS_PVT.IS_UPDATEABLE(
1886: p_loader_timestamp => p_loader_timestamp,
1887: p_created_by => G_CUST_REGION_REDO_TBL(l_index).created_by,
1888: p_creation_date => G_CUST_REGION_REDO_TBL(l_index).creation_date,
1889: p_last_updated_by => G_CUST_REGION_REDO_TBL(l_index).last_updated_by,