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.PSB_POSITION_CONTROL_PVT dependencies on FND_GLOBAL

Line 381: p_last_updated_by => FND_GLOBAL.USER_ID,

377: p_attribute29 => c_attrval_rec.attribute29,
378: p_attribute30 => c_attrval_rec.attribute30,
379: p_context => c_attrval_rec.context,
380: p_last_update_date => sysdate,
381: p_last_updated_by => FND_GLOBAL.USER_ID,
382: p_last_update_login => FND_GLOBAL.LOGIN_ID,
383: p_created_by => FND_GLOBAL.USER_ID,
384: p_creation_date => sysdate);
385:

Line 382: p_last_update_login => FND_GLOBAL.LOGIN_ID,

378: p_attribute30 => c_attrval_rec.attribute30,
379: p_context => c_attrval_rec.context,
380: p_last_update_date => sysdate,
381: p_last_updated_by => FND_GLOBAL.USER_ID,
382: p_last_update_login => FND_GLOBAL.LOGIN_ID,
383: p_created_by => FND_GLOBAL.USER_ID,
384: p_creation_date => sysdate);
385:
386: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 383: p_created_by => FND_GLOBAL.USER_ID,

379: p_context => c_attrval_rec.context,
380: p_last_update_date => sysdate,
381: p_last_updated_by => FND_GLOBAL.USER_ID,
382: p_last_update_login => FND_GLOBAL.LOGIN_ID,
383: p_created_by => FND_GLOBAL.USER_ID,
384: p_creation_date => sysdate);
385:
386: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
387: raise FND_API.G_EXC_ERROR;

Line 441: p_last_updated_by => FND_GLOBAL.USER_ID,

437: p_attribute29 => c_attrval_rec.attribute29,
438: p_attribute30 => c_attrval_rec.attribute30,
439: p_context => c_attrval_rec.context,
440: p_last_update_date => sysdate,
441: p_last_updated_by => FND_GLOBAL.USER_ID,
442: p_last_update_login => FND_GLOBAL.LOGIN_ID);
443:
444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
445: raise FND_API.G_EXC_ERROR;

Line 442: p_last_update_login => FND_GLOBAL.LOGIN_ID);

438: p_attribute30 => c_attrval_rec.attribute30,
439: p_context => c_attrval_rec.context,
440: p_last_update_date => sysdate,
441: p_last_updated_by => FND_GLOBAL.USER_ID,
442: p_last_update_login => FND_GLOBAL.LOGIN_ID);
443:
444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
445: raise FND_API.G_EXC_ERROR;
446: end if;

Line 720: p_last_updated_by => FND_GLOBAL.USER_ID,

716: p_attribute8 => c_elem_rec.attribute8,
717: p_attribute9 => c_elem_rec.attribute9,
718: p_attribute10 => c_elem_rec.attribute10,
719: p_last_update_date => sysdate,
720: p_last_updated_by => FND_GLOBAL.USER_ID,
721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
722: p_created_by => FND_GLOBAL.USER_ID,
723: p_creation_date => sysdate);
724:

Line 721: p_last_update_login => FND_GLOBAL.LOGIN_ID,

717: p_attribute9 => c_elem_rec.attribute9,
718: p_attribute10 => c_elem_rec.attribute10,
719: p_last_update_date => sysdate,
720: p_last_updated_by => FND_GLOBAL.USER_ID,
721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
722: p_created_by => FND_GLOBAL.USER_ID,
723: p_creation_date => sysdate);
724:
725: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 722: p_created_by => FND_GLOBAL.USER_ID,

718: p_attribute10 => c_elem_rec.attribute10,
719: p_last_update_date => sysdate,
720: p_last_updated_by => FND_GLOBAL.USER_ID,
721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
722: p_created_by => FND_GLOBAL.USER_ID,
723: p_creation_date => sysdate);
724:
725: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
726: raise FND_API.G_EXC_ERROR;

Line 749: p_last_updated_by => FND_GLOBAL.USER_ID,

745: p_name => c_elemoptions_rec.name,
746: p_grade_step => c_elemoptions_rec.grade_step,
747: p_sequence_number => c_elemoptions_rec.sequence_number,
748: p_last_update_date => sysdate,
749: p_last_updated_by => FND_GLOBAL.USER_ID,
750: p_last_update_login => FND_GLOBAL.LOGIN_ID,
751: p_created_by => FND_GLOBAL.USER_ID,
752: p_creation_date => sysdate);
753:

Line 750: p_last_update_login => FND_GLOBAL.LOGIN_ID,

746: p_grade_step => c_elemoptions_rec.grade_step,
747: p_sequence_number => c_elemoptions_rec.sequence_number,
748: p_last_update_date => sysdate,
749: p_last_updated_by => FND_GLOBAL.USER_ID,
750: p_last_update_login => FND_GLOBAL.LOGIN_ID,
751: p_created_by => FND_GLOBAL.USER_ID,
752: p_creation_date => sysdate);
753:
754: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 751: p_created_by => FND_GLOBAL.USER_ID,

747: p_sequence_number => c_elemoptions_rec.sequence_number,
748: p_last_update_date => sysdate,
749: p_last_updated_by => FND_GLOBAL.USER_ID,
750: p_last_update_login => FND_GLOBAL.LOGIN_ID,
751: p_created_by => FND_GLOBAL.USER_ID,
752: p_creation_date => sysdate);
753:
754: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
755: raise FND_API.G_EXC_ERROR;

Line 837: p_last_updated_by => FND_GLOBAL.USER_ID,

833: p_position_set_group_id => l_position_set_group_id,
834: p_pay_element_id => l_pay_element_id,
835: p_name => c_possetgrp_rec.name,
836: p_last_update_date => sysdate,
837: p_last_updated_by => FND_GLOBAL.USER_ID,
838: p_last_update_login => FND_GLOBAL.LOGIN_ID,
839: p_created_by => FND_GLOBAL.USER_ID,
840: p_creation_date => sysdate);
841:

Line 838: p_last_update_login => FND_GLOBAL.LOGIN_ID,

834: p_pay_element_id => l_pay_element_id,
835: p_name => c_possetgrp_rec.name,
836: p_last_update_date => sysdate,
837: p_last_updated_by => FND_GLOBAL.USER_ID,
838: p_last_update_login => FND_GLOBAL.LOGIN_ID,
839: p_created_by => FND_GLOBAL.USER_ID,
840: p_creation_date => sysdate);
841:
842: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 839: p_created_by => FND_GLOBAL.USER_ID,

835: p_name => c_possetgrp_rec.name,
836: p_last_update_date => sysdate,
837: p_last_updated_by => FND_GLOBAL.USER_ID,
838: p_last_update_login => FND_GLOBAL.LOGIN_ID,
839: p_created_by => FND_GLOBAL.USER_ID,
840: p_creation_date => sysdate);
841:
842: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
843: raise FND_API.G_EXC_ERROR;

Line 885: p_last_updated_by => FND_GLOBAL.USER_ID,

881: p_account_or_position_type =>c_posset_rec.account_or_position_type,
882: p_attribute_selection_type => c_posset_rec.attribute_selection_type,
883: p_business_group_id => c_posset_rec.business_group_id,
884: p_last_update_date => sysdate,
885: p_last_updated_by => FND_GLOBAL.USER_ID,
886: p_last_update_login => FND_GLOBAL.LOGIN_ID,
887: p_created_by => FND_GLOBAL.USER_ID,
888: p_creation_date => sysdate);
889:

Line 886: p_last_update_login => FND_GLOBAL.LOGIN_ID,

882: p_attribute_selection_type => c_posset_rec.attribute_selection_type,
883: p_business_group_id => c_posset_rec.business_group_id,
884: p_last_update_date => sysdate,
885: p_last_updated_by => FND_GLOBAL.USER_ID,
886: p_last_update_login => FND_GLOBAL.LOGIN_ID,
887: p_created_by => FND_GLOBAL.USER_ID,
888: p_creation_date => sysdate);
889:
890: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 887: p_created_by => FND_GLOBAL.USER_ID,

883: p_business_group_id => c_posset_rec.business_group_id,
884: p_last_update_date => sysdate,
885: p_last_updated_by => FND_GLOBAL.USER_ID,
886: p_last_update_login => FND_GLOBAL.LOGIN_ID,
887: p_created_by => FND_GLOBAL.USER_ID,
888: p_creation_date => sysdate);
889:
890: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
891: raise FND_API.G_EXC_ERROR;

Line 984: p_last_updated_by => FND_GLOBAL.USER_ID,

980: p_attribute8 => c_possetline_rec.attribute8,
981: p_attribute9 => c_possetline_rec.attribute9,
982: p_attribute10 => c_possetline_rec.attribute10,
983: p_last_update_date => sysdate,
984: p_last_updated_by => FND_GLOBAL.USER_ID,
985: p_last_update_login => FND_GLOBAL.LOGIN_ID,
986: p_created_by => FND_GLOBAL.USER_ID,
987: p_creation_date => sysdate);
988:

Line 985: p_last_update_login => FND_GLOBAL.LOGIN_ID,

981: p_attribute9 => c_possetline_rec.attribute9,
982: p_attribute10 => c_possetline_rec.attribute10,
983: p_last_update_date => sysdate,
984: p_last_updated_by => FND_GLOBAL.USER_ID,
985: p_last_update_login => FND_GLOBAL.LOGIN_ID,
986: p_created_by => FND_GLOBAL.USER_ID,
987: p_creation_date => sysdate);
988:
989: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 986: p_created_by => FND_GLOBAL.USER_ID,

982: p_attribute10 => c_possetline_rec.attribute10,
983: p_last_update_date => sysdate,
984: p_last_updated_by => FND_GLOBAL.USER_ID,
985: p_last_update_login => FND_GLOBAL.LOGIN_ID,
986: p_created_by => FND_GLOBAL.USER_ID,
987: p_creation_date => sysdate);
988:
989: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
990: raise FND_API.G_EXC_ERROR;

Line 1014: p_last_updated_by => FND_GLOBAL.USER_ID,

1010: p_line_sequence_id => l_line_sequence_id,
1011: p_attribute_value_id => l_attribute_value_id,
1012: p_attribute_value => c_possetlineval_rec.attribute_value,
1013: p_last_update_date => sysdate,
1014: p_last_updated_by => FND_GLOBAL.USER_ID,
1015: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1016: p_created_by => FND_GLOBAL.USER_ID,
1017: p_creation_date => sysdate);
1018:

Line 1015: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1011: p_attribute_value_id => l_attribute_value_id,
1012: p_attribute_value => c_possetlineval_rec.attribute_value,
1013: p_last_update_date => sysdate,
1014: p_last_updated_by => FND_GLOBAL.USER_ID,
1015: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1016: p_created_by => FND_GLOBAL.USER_ID,
1017: p_creation_date => sysdate);
1018:
1019: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1016: p_created_by => FND_GLOBAL.USER_ID,

1012: p_attribute_value => c_possetlineval_rec.attribute_value,
1013: p_last_update_date => sysdate,
1014: p_last_updated_by => FND_GLOBAL.USER_ID,
1015: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1016: p_created_by => FND_GLOBAL.USER_ID,
1017: p_creation_date => sysdate);
1018:
1019: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1020: raise FND_API.G_EXC_ERROR;

Line 1131: p_last_updated_by => FND_GLOBAL.USER_ID,

1127: p_attribute8 => c_possetline_rec.attribute8,
1128: p_attribute9 => c_possetline_rec.attribute9,
1129: p_attribute10 => c_possetline_rec.attribute10,
1130: p_last_update_date => sysdate,
1131: p_last_updated_by => FND_GLOBAL.USER_ID,
1132: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1133: p_created_by => FND_GLOBAL.USER_ID,
1134: p_creation_date => sysdate);
1135:

Line 1132: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1128: p_attribute9 => c_possetline_rec.attribute9,
1129: p_attribute10 => c_possetline_rec.attribute10,
1130: p_last_update_date => sysdate,
1131: p_last_updated_by => FND_GLOBAL.USER_ID,
1132: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1133: p_created_by => FND_GLOBAL.USER_ID,
1134: p_creation_date => sysdate);
1135:
1136: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1133: p_created_by => FND_GLOBAL.USER_ID,

1129: p_attribute10 => c_possetline_rec.attribute10,
1130: p_last_update_date => sysdate,
1131: p_last_updated_by => FND_GLOBAL.USER_ID,
1132: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1133: p_created_by => FND_GLOBAL.USER_ID,
1134: p_creation_date => sysdate);
1135:
1136: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1137: raise FND_API.G_EXC_ERROR;

Line 1161: p_last_updated_by => FND_GLOBAL.USER_ID,

1157: p_line_sequence_id => l_line_sequence_id,
1158: p_attribute_value_id => l_attribute_value_id,
1159: p_attribute_value => c_possetlineval_rec.attribute_value,
1160: p_last_update_date => sysdate,
1161: p_last_updated_by => FND_GLOBAL.USER_ID,
1162: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1163: p_created_by => FND_GLOBAL.USER_ID,
1164: p_creation_date => sysdate);
1165:

Line 1162: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1158: p_attribute_value_id => l_attribute_value_id,
1159: p_attribute_value => c_possetlineval_rec.attribute_value,
1160: p_last_update_date => sysdate,
1161: p_last_updated_by => FND_GLOBAL.USER_ID,
1162: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1163: p_created_by => FND_GLOBAL.USER_ID,
1164: p_creation_date => sysdate);
1165:
1166: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1163: p_created_by => FND_GLOBAL.USER_ID,

1159: p_attribute_value => c_possetlineval_rec.attribute_value,
1160: p_last_update_date => sysdate,
1161: p_last_updated_by => FND_GLOBAL.USER_ID,
1162: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1163: p_created_by => FND_GLOBAL.USER_ID,
1164: p_creation_date => sysdate);
1165:
1166: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1167: raise FND_API.G_EXC_ERROR;

Line 1205: p_last_updated_by => FND_GLOBAL.USER_ID,

1201: p_line_sequence_id => l_line_sequence_id,
1202: p_attribute_value_id => l_attribute_value_id,
1203: p_attribute_value => c_possetlineval_rec.attribute_value,
1204: p_last_update_date => sysdate,
1205: p_last_updated_by => FND_GLOBAL.USER_ID,
1206: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1207: p_created_by => FND_GLOBAL.USER_ID,
1208: p_creation_date => sysdate);
1209:

Line 1206: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1202: p_attribute_value_id => l_attribute_value_id,
1203: p_attribute_value => c_possetlineval_rec.attribute_value,
1204: p_last_update_date => sysdate,
1205: p_last_updated_by => FND_GLOBAL.USER_ID,
1206: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1207: p_created_by => FND_GLOBAL.USER_ID,
1208: p_creation_date => sysdate);
1209:
1210: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1207: p_created_by => FND_GLOBAL.USER_ID,

1203: p_attribute_value => c_possetlineval_rec.attribute_value,
1204: p_last_update_date => sysdate,
1205: p_last_updated_by => FND_GLOBAL.USER_ID,
1206: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1207: p_created_by => FND_GLOBAL.USER_ID,
1208: p_creation_date => sysdate);
1209:
1210: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1211: raise FND_API.G_EXC_ERROR;

Line 1246: p_last_updated_by => FND_GLOBAL.USER_ID,

1242: p_account_or_position_type => c_posset_rec.account_or_position_type,
1243: p_attribute_selection_type => 'O',
1244: p_business_group_id => c_posset_rec.business_group_id,
1245: p_last_update_date => sysdate,
1246: p_last_updated_by => FND_GLOBAL.USER_ID,
1247: p_last_update_login => FND_GLOBAL.LOGIN_ID);
1248:
1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1250: raise FND_API.G_EXC_ERROR;

Line 1247: p_last_update_login => FND_GLOBAL.LOGIN_ID);

1243: p_attribute_selection_type => 'O',
1244: p_business_group_id => c_posset_rec.business_group_id,
1245: p_last_update_date => sysdate,
1246: p_last_updated_by => FND_GLOBAL.USER_ID,
1247: p_last_update_login => FND_GLOBAL.LOGIN_ID);
1248:
1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1250: raise FND_API.G_EXC_ERROR;
1251: end if;

Line 1291: p_last_updated_by => FND_GLOBAL.USER_ID,

1287: /* Budget Revision Rules Enhancement End */
1288: p_effective_start_date => null,
1289: p_effective_end_date => null,
1290: p_last_update_date => sysdate,
1291: p_last_updated_by => FND_GLOBAL.USER_ID,
1292: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1293: p_created_by => FND_GLOBAL.USER_ID,
1294: p_creation_date => sysdate);
1295:

Line 1292: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1288: p_effective_start_date => null,
1289: p_effective_end_date => null,
1290: p_last_update_date => sysdate,
1291: p_last_updated_by => FND_GLOBAL.USER_ID,
1292: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1293: p_created_by => FND_GLOBAL.USER_ID,
1294: p_creation_date => sysdate);
1295:
1296: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1293: p_created_by => FND_GLOBAL.USER_ID,

1289: p_effective_end_date => null,
1290: p_last_update_date => sysdate,
1291: p_last_updated_by => FND_GLOBAL.USER_ID,
1292: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1293: p_created_by => FND_GLOBAL.USER_ID,
1294: p_creation_date => sysdate);
1295:
1296: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1297: raise FND_API.G_EXC_ERROR;

Line 1355: p_last_updated_by => FND_GLOBAL.USER_ID,

1351: p_segment28 => c_elemdist_rec.segment28,
1352: p_segment29 => c_elemdist_rec.segment29,
1353: p_segment30 => c_elemdist_rec.segment30,
1354: p_last_update_date => sysdate,
1355: p_last_updated_by => FND_GLOBAL.USER_ID,
1356: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1357: p_created_by => FND_GLOBAL.USER_ID,
1358: p_creation_date => sysdate);
1359:

Line 1356: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1352: p_segment29 => c_elemdist_rec.segment29,
1353: p_segment30 => c_elemdist_rec.segment30,
1354: p_last_update_date => sysdate,
1355: p_last_updated_by => FND_GLOBAL.USER_ID,
1356: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1357: p_created_by => FND_GLOBAL.USER_ID,
1358: p_creation_date => sysdate);
1359:
1360: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1357: p_created_by => FND_GLOBAL.USER_ID,

1353: p_segment30 => c_elemdist_rec.segment30,
1354: p_last_update_date => sysdate,
1355: p_last_updated_by => FND_GLOBAL.USER_ID,
1356: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1357: p_created_by => FND_GLOBAL.USER_ID,
1358: p_creation_date => sysdate);
1359:
1360: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1361: raise FND_API.G_EXC_ERROR;

Line 1415: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1411: P_ATTRIBUTE8 => c_elem_rec.attribute8,
1412: P_ATTRIBUTE9 => c_elem_rec.attribute9,
1413: P_ATTRIBUTE10 => c_elem_rec.attribute10,
1414: P_LAST_UPDATE_DATE => sysdate,
1415: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1416: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1417:
1418: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1419: raise FND_API.G_EXC_ERROR;

Line 1416: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1412: P_ATTRIBUTE9 => c_elem_rec.attribute9,
1413: P_ATTRIBUTE10 => c_elem_rec.attribute10,
1414: P_LAST_UPDATE_DATE => sysdate,
1415: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1416: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1417:
1418: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1419: raise FND_API.G_EXC_ERROR;
1420: end if;

Line 1456: p_last_updated_by => FND_GLOBAL.USER_ID,

1452: p_name => c_elemoptions_rec.name,
1453: p_grade_step => c_elemoptions_rec.grade_step,
1454: p_sequence_number => c_elemoptions_rec.sequence_number,
1455: p_last_update_date => sysdate,
1456: p_last_updated_by => FND_GLOBAL.USER_ID,
1457: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1458: p_created_by => FND_GLOBAL.USER_ID,
1459: p_creation_date => sysdate);
1460:

Line 1457: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1453: p_grade_step => c_elemoptions_rec.grade_step,
1454: p_sequence_number => c_elemoptions_rec.sequence_number,
1455: p_last_update_date => sysdate,
1456: p_last_updated_by => FND_GLOBAL.USER_ID,
1457: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1458: p_created_by => FND_GLOBAL.USER_ID,
1459: p_creation_date => sysdate);
1460:
1461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1458: p_created_by => FND_GLOBAL.USER_ID,

1454: p_sequence_number => c_elemoptions_rec.sequence_number,
1455: p_last_update_date => sysdate,
1456: p_last_updated_by => FND_GLOBAL.USER_ID,
1457: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1458: p_created_by => FND_GLOBAL.USER_ID,
1459: p_creation_date => sysdate);
1460:
1461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1462: raise FND_API.G_EXC_ERROR;

Line 1691: p_last_updated_by => FND_GLOBAL.USER_ID,

1687: p_attribute8 => c_elem_rec.attribute8,
1688: p_attribute9 => c_elem_rec.attribute9,
1689: p_attribute10 => c_elem_rec.attribute10,
1690: p_last_update_date => sysdate,
1691: p_last_updated_by => FND_GLOBAL.USER_ID,
1692: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1693: p_created_by => FND_GLOBAL.USER_ID,
1694: p_creation_date => sysdate);
1695:

Line 1692: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1688: p_attribute9 => c_elem_rec.attribute9,
1689: p_attribute10 => c_elem_rec.attribute10,
1690: p_last_update_date => sysdate,
1691: p_last_updated_by => FND_GLOBAL.USER_ID,
1692: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1693: p_created_by => FND_GLOBAL.USER_ID,
1694: p_creation_date => sysdate);
1695:
1696: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1693: p_created_by => FND_GLOBAL.USER_ID,

1689: p_attribute10 => c_elem_rec.attribute10,
1690: p_last_update_date => sysdate,
1691: p_last_updated_by => FND_GLOBAL.USER_ID,
1692: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1693: p_created_by => FND_GLOBAL.USER_ID,
1694: p_creation_date => sysdate);
1695:
1696: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1697: raise FND_API.G_EXC_ERROR;

Line 1720: p_last_updated_by => FND_GLOBAL.USER_ID,

1716: p_name => c_elemoptions_rec.name,
1717: p_grade_step => c_elemoptions_rec.grade_step,
1718: p_sequence_number => c_elemoptions_rec.sequence_number,
1719: p_last_update_date => sysdate,
1720: p_last_updated_by => FND_GLOBAL.USER_ID,
1721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1722: p_created_by => FND_GLOBAL.USER_ID,
1723: p_creation_date => sysdate);
1724:

Line 1721: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1717: p_grade_step => c_elemoptions_rec.grade_step,
1718: p_sequence_number => c_elemoptions_rec.sequence_number,
1719: p_last_update_date => sysdate,
1720: p_last_updated_by => FND_GLOBAL.USER_ID,
1721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1722: p_created_by => FND_GLOBAL.USER_ID,
1723: p_creation_date => sysdate);
1724:
1725: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1722: p_created_by => FND_GLOBAL.USER_ID,

1718: p_sequence_number => c_elemoptions_rec.sequence_number,
1719: p_last_update_date => sysdate,
1720: p_last_updated_by => FND_GLOBAL.USER_ID,
1721: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1722: p_created_by => FND_GLOBAL.USER_ID,
1723: p_creation_date => sysdate);
1724:
1725: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1726: raise FND_API.G_EXC_ERROR;

Line 1842: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

1838: P_ATTRIBUTE8 => c_elem_rec.attribute8,
1839: P_ATTRIBUTE9 => c_elem_rec.attribute9,
1840: P_ATTRIBUTE10 => c_elem_rec.attribute10,
1841: P_LAST_UPDATE_DATE => sysdate,
1842: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1843: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1844:
1845: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1846: raise FND_API.G_EXC_ERROR;

Line 1843: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);

1839: P_ATTRIBUTE9 => c_elem_rec.attribute9,
1840: P_ATTRIBUTE10 => c_elem_rec.attribute10,
1841: P_LAST_UPDATE_DATE => sysdate,
1842: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1843: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID);
1844:
1845: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1846: raise FND_API.G_EXC_ERROR;
1847: end if;

Line 1883: p_last_updated_by => FND_GLOBAL.USER_ID,

1879: p_name => c_elemoptions_rec.name,
1880: p_grade_step => c_elemoptions_rec.grade_step,
1881: p_sequence_number => c_elemoptions_rec.sequence_number,
1882: p_last_update_date => sysdate,
1883: p_last_updated_by => FND_GLOBAL.USER_ID,
1884: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1885: p_created_by => FND_GLOBAL.USER_ID,
1886: p_creation_date => sysdate);
1887:

Line 1884: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1880: p_grade_step => c_elemoptions_rec.grade_step,
1881: p_sequence_number => c_elemoptions_rec.sequence_number,
1882: p_last_update_date => sysdate,
1883: p_last_updated_by => FND_GLOBAL.USER_ID,
1884: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1885: p_created_by => FND_GLOBAL.USER_ID,
1886: p_creation_date => sysdate);
1887:
1888: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 1885: p_created_by => FND_GLOBAL.USER_ID,

1881: p_sequence_number => c_elemoptions_rec.sequence_number,
1882: p_last_update_date => sysdate,
1883: p_last_updated_by => FND_GLOBAL.USER_ID,
1884: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1885: p_created_by => FND_GLOBAL.USER_ID,
1886: p_creation_date => sysdate);
1887:
1888: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1889: raise FND_API.G_EXC_ERROR;

Line 2113: FND_GLOBAL.USER_ID,

2109: l_last_name(i),
2110: l_middle_names(i),
2111: l_title(i),
2112: sysdate,
2113: FND_GLOBAL.USER_ID,
2114: sysdate,
2115: FND_GLOBAL.USER_ID,
2116: FND_GLOBAL.LOGIN_ID);
2117:

Line 2115: FND_GLOBAL.USER_ID,

2111: l_title(i),
2112: sysdate,
2113: FND_GLOBAL.USER_ID,
2114: sysdate,
2115: FND_GLOBAL.USER_ID,
2116: FND_GLOBAL.LOGIN_ID);
2117:
2118: EXIT WHEN C_Emp_All%NOTFOUND;
2119:

Line 2116: FND_GLOBAL.LOGIN_ID);

2112: sysdate,
2113: FND_GLOBAL.USER_ID,
2114: sysdate,
2115: FND_GLOBAL.USER_ID,
2116: FND_GLOBAL.LOGIN_ID);
2117:
2118: EXIT WHEN C_Emp_All%NOTFOUND;
2119:
2120: END LOOP;

Line 2657: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,

2653: ins_distribution_percent(i), ins_global_default_flag(i),
2654: ins_dist_default_rule_id(i), ins_project_id(i), ins_task_id(i),
2655: ins_award_id(i), ins_exp_type(i), ins_exp_org_id(i),
2656: ins_cost_alloc_key_flex_id(i), ins_description(i),
2657: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
2658: FND_GLOBAL.USER_ID, SYSDATE
2659: );
2660: /* Bug 4060926 Start */
2661: l_debug_info := ' Bulk Insertion of the manipulated disr completed.';

Line 2658: FND_GLOBAL.USER_ID, SYSDATE

2654: ins_dist_default_rule_id(i), ins_project_id(i), ins_task_id(i),
2655: ins_award_id(i), ins_exp_type(i), ins_exp_org_id(i),
2656: ins_cost_alloc_key_flex_id(i), ins_description(i),
2657: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
2658: FND_GLOBAL.USER_ID, SYSDATE
2659: );
2660: /* Bug 4060926 Start */
2661: l_debug_info := ' Bulk Insertion of the manipulated disr completed.';
2662: /* Bug 4060926 End */

Line 4765: last_updated_by = FND_GLOBAL.USER_ID,

4761: FORALL i IN 1..l_count_fte
4762: UPDATE PSB_POSITION_FTE
4763: SET fte =l_fte_fte(i),
4764: last_update_date = sysdate,
4765: last_updated_by = FND_GLOBAL.USER_ID,
4766: last_update_login = FND_GLOBAL.LOGIN_ID
4767: WHERE position_id = l_fte_position_id(i)
4768: AND nvl(hr_budget_id,-1) = nvl(p_hr_budget_id,-1)
4769: AND budget_revision_id is null

Line 4766: last_update_login = FND_GLOBAL.LOGIN_ID

4762: UPDATE PSB_POSITION_FTE
4763: SET fte =l_fte_fte(i),
4764: last_update_date = sysdate,
4765: last_updated_by = FND_GLOBAL.USER_ID,
4766: last_update_login = FND_GLOBAL.LOGIN_ID
4767: WHERE position_id = l_fte_position_id(i)
4768: AND nvl(hr_budget_id,-1) = nvl(p_hr_budget_id,-1)
4769: AND budget_revision_id is null
4770: AND base_line_version = l_base_line_version

Line 4834: last_updated_by = FND_GLOBAL.USER_ID,

4830: FORALL i IN 1..l_count_costs
4831: UPDATE PSB_POSITION_COSTS
4832: SET element_cost = l_cost_element_cost(i),
4833: last_update_date = sysdate,
4834: last_updated_by = FND_GLOBAL.USER_ID,
4835: last_update_login = FND_GLOBAL.LOGIN_ID
4836: WHERE position_id = l_cost_position_id(i)
4837: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
4838: AND pay_element_id = l_cost_element_id(i)

Line 4835: last_update_login = FND_GLOBAL.LOGIN_ID

4831: UPDATE PSB_POSITION_COSTS
4832: SET element_cost = l_cost_element_cost(i),
4833: last_update_date = sysdate,
4834: last_updated_by = FND_GLOBAL.USER_ID,
4835: last_update_login = FND_GLOBAL.LOGIN_ID
4836: WHERE position_id = l_cost_position_id(i)
4837: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
4838: AND pay_element_id = l_cost_element_id(i)
4839: AND currency_code = l_cost_currency_code(i)

Line 4911: last_updated_by = FND_GLOBAL.USER_ID,

4907: UPDATE PSB_POSITION_ACCOUNTS
4908: SET amount = l_account_amount(i),
4909: budget_group_id = l_account_bg_id(i),
4910: last_update_date = sysdate,
4911: last_updated_by = FND_GLOBAL.USER_ID,
4912: last_update_login = FND_GLOBAL.LOGIN_ID
4913: WHERE position_id = l_account_position_id(i)
4914: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
4915: AND code_combination_id = l_account_cc_id(i)

Line 4912: last_update_login = FND_GLOBAL.LOGIN_ID

4908: SET amount = l_account_amount(i),
4909: budget_group_id = l_account_bg_id(i),
4910: last_update_date = sysdate,
4911: last_updated_by = FND_GLOBAL.USER_ID,
4912: last_update_login = FND_GLOBAL.LOGIN_ID
4913: WHERE position_id = l_account_position_id(i)
4914: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
4915: AND code_combination_id = l_account_cc_id(i)
4916: AND currency_code = l_account_currency_code(i)

Line 5003: last_updated_by = FND_GLOBAL.USER_ID,

4999: FORALL i IN 1..l_count_fte
5000: UPDATE PSB_POSITION_FTE
5001: SET fte = l_fte_fte(i),
5002: last_update_date = sysdate,
5003: last_updated_by = FND_GLOBAL.USER_ID,
5004: last_update_login = FND_GLOBAL.LOGIN_ID
5005: WHERE position_id = l_fte_position_id(i)
5006: AND nvl(hr_budget_id,-1) = nvl(p_hr_budget_id,-1)
5007: AND budget_revision_id is null

Line 5004: last_update_login = FND_GLOBAL.LOGIN_ID

5000: UPDATE PSB_POSITION_FTE
5001: SET fte = l_fte_fte(i),
5002: last_update_date = sysdate,
5003: last_updated_by = FND_GLOBAL.USER_ID,
5004: last_update_login = FND_GLOBAL.LOGIN_ID
5005: WHERE position_id = l_fte_position_id(i)
5006: AND nvl(hr_budget_id,-1) = nvl(p_hr_budget_id,-1)
5007: AND budget_revision_id is null
5008: AND base_line_version = l_base_line_version

Line 5073: last_updated_by = FND_GLOBAL.USER_ID,

5069: FORALL i IN 1..l_count_costs
5070: UPDATE PSB_POSITION_COSTS
5071: SET element_cost = l_cost_element_cost(i),
5072: last_update_date = sysdate,
5073: last_updated_by = FND_GLOBAL.USER_ID,
5074: last_update_login = FND_GLOBAL.LOGIN_ID
5075: WHERE position_id = l_cost_position_id(i)
5076: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
5077: AND pay_element_id = l_cost_element_id(i)

Line 5074: last_update_login = FND_GLOBAL.LOGIN_ID

5070: UPDATE PSB_POSITION_COSTS
5071: SET element_cost = l_cost_element_cost(i),
5072: last_update_date = sysdate,
5073: last_updated_by = FND_GLOBAL.USER_ID,
5074: last_update_login = FND_GLOBAL.LOGIN_ID
5075: WHERE position_id = l_cost_position_id(i)
5076: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
5077: AND pay_element_id = l_cost_element_id(i)
5078: AND currency_code = l_cost_currency_code(i)

Line 5152: last_updated_by = FND_GLOBAL.USER_ID,

5148: UPDATE PSB_POSITION_ACCOUNTS
5149: SET amount = l_account_amount(i),
5150: budget_group_id = l_account_bg_id(i),
5151: last_update_date = sysdate,
5152: last_updated_by = FND_GLOBAL.USER_ID,
5153: last_update_login = FND_GLOBAL.LOGIN_ID
5154: WHERE position_id = l_account_position_id(i)
5155: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
5156: AND code_combination_id = l_account_cc_id(i)

Line 5153: last_update_login = FND_GLOBAL.LOGIN_ID

5149: SET amount = l_account_amount(i),
5150: budget_group_id = l_account_bg_id(i),
5151: last_update_date = sysdate,
5152: last_updated_by = FND_GLOBAL.USER_ID,
5153: last_update_login = FND_GLOBAL.LOGIN_ID
5154: WHERE position_id = l_account_position_id(i)
5155: AND nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
5156: AND code_combination_id = l_account_cc_id(i)
5157: AND currency_code = l_account_currency_code(i)

Line 5273: interface_last_updated_by = FND_GLOBAL.USER_ID,

5269: set org_id = FND_PROFILE.VALUE('ORG_ID'),
5270: transfer_to_interface = p_transfer_to_interface,
5271: transfer_to_hrms = p_transfer_to_hrms,
5272: interface_last_update_date = sysdate,
5273: interface_last_updated_by = FND_GLOBAL.USER_ID,
5274: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5275: hrms_last_update_date = sysdate,
5276: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5277: hrms_last_update_login = FND_GLOBAL.LOGIN_ID

Line 5274: interface_last_update_login = FND_GLOBAL.LOGIN_ID,

5270: transfer_to_interface = p_transfer_to_interface,
5271: transfer_to_hrms = p_transfer_to_hrms,
5272: interface_last_update_date = sysdate,
5273: interface_last_updated_by = FND_GLOBAL.USER_ID,
5274: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5275: hrms_last_update_date = sysdate,
5276: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5277: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5278: where event_type = p_event_type

Line 5276: hrms_last_updated_by = FND_GLOBAL.USER_ID,

5272: interface_last_update_date = sysdate,
5273: interface_last_updated_by = FND_GLOBAL.USER_ID,
5274: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5275: hrms_last_update_date = sysdate,
5276: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5277: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5278: where event_type = p_event_type
5279: and source_id = p_source_id
5280: and from_budget_year_id = p_from_budget_year_id

Line 5277: hrms_last_update_login = FND_GLOBAL.LOGIN_ID

5273: interface_last_updated_by = FND_GLOBAL.USER_ID,
5274: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5275: hrms_last_update_date = sysdate,
5276: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5277: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5278: where event_type = p_event_type
5279: and source_id = p_source_id
5280: and from_budget_year_id = p_from_budget_year_id
5281: and to_budget_year_id = p_to_budget_year_id

Line 5293: interface_last_updated_by = FND_GLOBAL.USER_ID,

5289: set org_id = FND_PROFILE.VALUE('ORG_ID'),
5290: transfer_to_interface = p_transfer_to_interface,
5291: transfer_to_hrms = p_transfer_to_hrms,
5292: interface_last_update_date = sysdate,
5293: interface_last_updated_by = FND_GLOBAL.USER_ID,
5294: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5295: hrms_last_update_date = sysdate,
5296: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5297: hrms_last_update_login = FND_GLOBAL.LOGIN_ID

Line 5294: interface_last_update_login = FND_GLOBAL.LOGIN_ID,

5290: transfer_to_interface = p_transfer_to_interface,
5291: transfer_to_hrms = p_transfer_to_hrms,
5292: interface_last_update_date = sysdate,
5293: interface_last_updated_by = FND_GLOBAL.USER_ID,
5294: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5295: hrms_last_update_date = sysdate,
5296: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5297: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5298: where event_type = p_event_type

Line 5296: hrms_last_updated_by = FND_GLOBAL.USER_ID,

5292: interface_last_update_date = sysdate,
5293: interface_last_updated_by = FND_GLOBAL.USER_ID,
5294: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5295: hrms_last_update_date = sysdate,
5296: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5297: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5298: where event_type = p_event_type
5299: and source_id = p_source_id
5300: and from_budget_year_id = p_from_budget_year_id

Line 5297: hrms_last_update_login = FND_GLOBAL.LOGIN_ID

5293: interface_last_updated_by = FND_GLOBAL.USER_ID,
5294: interface_last_update_login = FND_GLOBAL.LOGIN_ID,
5295: hrms_last_update_date = sysdate,
5296: hrms_last_updated_by = FND_GLOBAL.USER_ID,
5297: hrms_last_update_login = FND_GLOBAL.LOGIN_ID
5298: where event_type = p_event_type
5299: and source_id = p_source_id
5300: and from_budget_year_id = p_from_budget_year_id
5301: and to_budget_year_id = p_to_budget_year_id

Line 5339: FND_GLOBAL.USER_ID,

5335: p_from_budget_year_id,
5336: p_to_budget_year_id,
5337: p_transfer_to_interface,
5338: p_transfer_to_hrms,
5339: FND_GLOBAL.USER_ID,
5340: sysdate,
5341: sysdate,
5342: FND_GLOBAL.USER_ID,
5343: FND_GLOBAL.LOGIN_ID,

Line 5342: FND_GLOBAL.USER_ID,

5338: p_transfer_to_hrms,
5339: FND_GLOBAL.USER_ID,
5340: sysdate,
5341: sysdate,
5342: FND_GLOBAL.USER_ID,
5343: FND_GLOBAL.LOGIN_ID,
5344: FND_GLOBAL.USER_ID,
5345: sysdate,
5346: sysdate,

Line 5343: FND_GLOBAL.LOGIN_ID,

5339: FND_GLOBAL.USER_ID,
5340: sysdate,
5341: sysdate,
5342: FND_GLOBAL.USER_ID,
5343: FND_GLOBAL.LOGIN_ID,
5344: FND_GLOBAL.USER_ID,
5345: sysdate,
5346: sysdate,
5347: FND_GLOBAL.USER_ID,

Line 5344: FND_GLOBAL.USER_ID,

5340: sysdate,
5341: sysdate,
5342: FND_GLOBAL.USER_ID,
5343: FND_GLOBAL.LOGIN_ID,
5344: FND_GLOBAL.USER_ID,
5345: sysdate,
5346: sysdate,
5347: FND_GLOBAL.USER_ID,
5348: FND_GLOBAL.LOGIN_ID) RETURNING position_event_id into l_position_event_id;

Line 5347: FND_GLOBAL.USER_ID,

5343: FND_GLOBAL.LOGIN_ID,
5344: FND_GLOBAL.USER_ID,
5345: sysdate,
5346: sysdate,
5347: FND_GLOBAL.USER_ID,
5348: FND_GLOBAL.LOGIN_ID) RETURNING position_event_id into l_position_event_id;
5349:
5350: end;
5351: end if;

Line 5348: FND_GLOBAL.LOGIN_ID) RETURNING position_event_id into l_position_event_id;

5344: FND_GLOBAL.USER_ID,
5345: sysdate,
5346: sysdate,
5347: FND_GLOBAL.USER_ID,
5348: FND_GLOBAL.LOGIN_ID) RETURNING position_event_id into l_position_event_id;
5349:
5350: end;
5351: end if;
5352:

Line 5825: sysdate, sysdate, FND_GLOBAL.USER_ID,

5821: LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, SYSTEM_DATA_EXTRACT)
5822: VALUES (PSB_DATA_EXTRACTS_S.NEXTVAL, l_data_extract_name, 'CREATE',
5823: l_root_set_of_books_id, l_business_group_id, l_root_budget_group_id,
5824: l_position_id_flex_num, null, sysdate,
5825: sysdate, sysdate, FND_GLOBAL.USER_ID,
5826: FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate, 'Y') RETURNING data_extract_id into l_system_data_extract_id;
5827:
5828: end;
5829: end if;

Line 5826: FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate, 'Y') RETURNING data_extract_id into l_system_data_extract_id;

5822: VALUES (PSB_DATA_EXTRACTS_S.NEXTVAL, l_data_extract_name, 'CREATE',
5823: l_root_set_of_books_id, l_business_group_id, l_root_budget_group_id,
5824: l_position_id_flex_num, null, sysdate,
5825: sysdate, sysdate, FND_GLOBAL.USER_ID,
5826: FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate, 'Y') RETURNING data_extract_id into l_system_data_extract_id;
5827:
5828: end;
5829: end if;
5830:

Line 6247: p_amount, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)

6243: base_line_version, start_date, end_date, code_combination_id, currency_code,
6244: amount, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6245: values (PSB_POSITION_ACCOUNTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_budget_group_id,
6246: p_base_line_version, p_start_date, p_end_date, p_code_combination_id, p_currency_code,
6247: p_amount, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
6248: RETURNING position_account_line_id into l_position_account_line_id;
6249:
6250: -- Initialize API return status to success
6251: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6305: last_updated_by = FND_GLOBAL.USER_ID,

6301: budget_group_id = p_budget_group_id,
6302: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6303: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
6304: last_update_date = sysdate,
6305: last_updated_by = FND_GLOBAL.USER_ID,
6306: last_update_login = FND_GLOBAL.LOGIN_ID
6307: where position_account_line_id = p_position_account_line_id;
6308:
6309: -- Initialize API return status to success

Line 6306: last_update_login = FND_GLOBAL.LOGIN_ID

6302: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6303: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
6304: last_update_date = sysdate,
6305: last_updated_by = FND_GLOBAL.USER_ID,
6306: last_update_login = FND_GLOBAL.LOGIN_ID
6307: where position_account_line_id = p_position_account_line_id;
6308:
6309: -- Initialize API return status to success
6310: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6470: last_updated_by = FND_GLOBAL.USER_ID,

6466: update PSB_POSITION_ACCOUNTS
6467: set amount = p_amount,
6468: budget_group_id = p_budget_group_id,
6469: last_update_date = sysdate,
6470: last_updated_by = FND_GLOBAL.USER_ID,
6471: last_update_login = FND_GLOBAL.LOGIN_ID
6472: where position_id = p_position_id
6473: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
6474: and code_combination_id = p_code_combination_id

Line 6471: last_update_login = FND_GLOBAL.LOGIN_ID

6467: set amount = p_amount,
6468: budget_group_id = p_budget_group_id,
6469: last_update_date = sysdate,
6470: last_updated_by = FND_GLOBAL.USER_ID,
6471: last_update_login = FND_GLOBAL.LOGIN_ID
6472: where position_id = p_position_id
6473: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
6474: and code_combination_id = p_code_combination_id
6475: and currency_code = p_currency_code

Line 6845: p_element_cost, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)

6841: base_line_version, currency_code, start_date, end_date,
6842: element_cost, last_update_date, last_updated_by, last_update_login, created_by, creation_date)
6843: values (PSB_POSITION_COSTS_S.NEXTVAL, p_position_id, p_hr_budget_id, p_pay_element_id, p_budget_revision_id,
6844: p_base_line_version, p_currency_code, p_start_date, p_end_date,
6845: p_element_cost, sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID, FND_GLOBAL.USER_ID, sysdate)
6846: RETURNING position_element_line_id INTO l_position_element_line_id;
6847:
6848: -- Initialize API return status to success
6849: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6898: last_updated_by = FND_GLOBAL.USER_ID,

6894: set element_cost = p_element_cost,
6895: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6896: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
6897: last_update_date = sysdate,
6898: last_updated_by = FND_GLOBAL.USER_ID,
6899: last_update_login = FND_GLOBAL.LOGIN_ID
6900: where position_element_line_id = p_position_element_line_id;
6901:
6902: -- Initialize API return status to success

Line 6899: last_update_login = FND_GLOBAL.LOGIN_ID

6895: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
6896: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
6897: last_update_date = sysdate,
6898: last_updated_by = FND_GLOBAL.USER_ID,
6899: last_update_login = FND_GLOBAL.LOGIN_ID
6900: where position_element_line_id = p_position_element_line_id;
6901:
6902: -- Initialize API return status to success
6903: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7060: last_updated_by = FND_GLOBAL.USER_ID,

7056: /*For Bug No : 1808322 End*/
7057: update PSB_POSITION_COSTS
7058: set element_cost = p_element_cost,
7059: last_update_date = sysdate,
7060: last_updated_by = FND_GLOBAL.USER_ID,
7061: last_update_login = FND_GLOBAL.LOGIN_ID
7062: where position_id = p_position_id
7063: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7064: and pay_element_id = p_pay_element_id

Line 7061: last_update_login = FND_GLOBAL.LOGIN_ID

7057: update PSB_POSITION_COSTS
7058: set element_cost = p_element_cost,
7059: last_update_date = sysdate,
7060: last_updated_by = FND_GLOBAL.USER_ID,
7061: last_update_login = FND_GLOBAL.LOGIN_ID
7062: where position_id = p_position_id
7063: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7064: and pay_element_id = p_pay_element_id
7065: and currency_code = p_currency_code

Line 7423: p_start_date, p_end_date, nvl(p_fte, 0), sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,

7419: (position_fte_line_id, position_id, hr_budget_id, budget_revision_id, base_line_version,
7420: start_date, end_date, fte, last_update_date, last_updated_by, last_update_login,
7421: created_by, creation_date)
7422: VALUES (PSB_POSITION_FTE_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_base_line_version,
7423: p_start_date, p_end_date, nvl(p_fte, 0), sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
7424: FND_GLOBAL.USER_ID, sysdate) RETURNING position_fte_line_id INTO l_position_fte_line_id;
7425:
7426: -- Initialize API return status to success
7427: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7424: FND_GLOBAL.USER_ID, sysdate) RETURNING position_fte_line_id INTO l_position_fte_line_id;

7420: start_date, end_date, fte, last_update_date, last_updated_by, last_update_login,
7421: created_by, creation_date)
7422: VALUES (PSB_POSITION_FTE_S.NEXTVAL, p_position_id, p_hr_budget_id, p_budget_revision_id, p_base_line_version,
7423: p_start_date, p_end_date, nvl(p_fte, 0), sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
7424: FND_GLOBAL.USER_ID, sysdate) RETURNING position_fte_line_id INTO l_position_fte_line_id;
7425:
7426: -- Initialize API return status to success
7427: p_return_status := FND_API.G_RET_STS_SUCCESS;
7428:

Line 7479: last_updated_by = FND_GLOBAL.USER_ID,

7475: set fte = nvl(p_fte, 0),
7476: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
7477: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
7478: last_update_date = sysdate,
7479: last_updated_by = FND_GLOBAL.USER_ID,
7480: last_update_login = FND_GLOBAL.LOGIN_ID
7481: where position_fte_line_id = p_position_fte_line_id;
7482:
7483: -- Initialize API return status to success

Line 7480: last_update_login = FND_GLOBAL.LOGIN_ID

7476: start_date = decode(p_start_date, FND_API.G_MISS_DATE, start_date, p_start_date),
7477: end_date = decode(p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date),
7478: last_update_date = sysdate,
7479: last_updated_by = FND_GLOBAL.USER_ID,
7480: last_update_login = FND_GLOBAL.LOGIN_ID
7481: where position_fte_line_id = p_position_fte_line_id;
7482:
7483: -- Initialize API return status to success
7484: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7638: last_updated_by = FND_GLOBAL.USER_ID,

7634:
7635: update PSB_POSITION_FTE
7636: set fte = nvl(p_fte, 0),
7637: last_update_date = sysdate,
7638: last_updated_by = FND_GLOBAL.USER_ID,
7639: last_update_login = FND_GLOBAL.LOGIN_ID
7640: where position_id = p_position_id
7641: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7642: and nvl(budget_revision_id, -1) = nvl(p_budget_revision_id, -1)

Line 7639: last_update_login = FND_GLOBAL.LOGIN_ID

7635: update PSB_POSITION_FTE
7636: set fte = nvl(p_fte, 0),
7637: last_update_date = sysdate,
7638: last_updated_by = FND_GLOBAL.USER_ID,
7639: last_update_login = FND_GLOBAL.LOGIN_ID
7640: where position_id = p_position_id
7641: and nvl(hr_budget_id, -1) = nvl(p_hr_budget_id, -1)
7642: and nvl(budget_revision_id, -1) = nvl(p_budget_revision_id, -1)
7643: and nvl(base_line_version, FND_API.G_MISS_CHAR) = nvl(p_base_line_version, FND_API.G_MISS_CHAR)

Line 12274: p_last_updated_by => FND_GLOBAL.USER_ID,

12270: p_position_set_group_id => l_possetgrp_id,
12271: p_pay_element_id => p_new_pay_element_id,
12272: p_name => c_possetgrp_rec.name,
12273: p_last_update_date => sysdate,
12274: p_last_updated_by => FND_GLOBAL.USER_ID,
12275: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12276: p_created_by => FND_GLOBAL.USER_ID,
12277: p_creation_date => sysdate);
12278:

Line 12275: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12271: p_pay_element_id => p_new_pay_element_id,
12272: p_name => c_possetgrp_rec.name,
12273: p_last_update_date => sysdate,
12274: p_last_updated_by => FND_GLOBAL.USER_ID,
12275: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12276: p_created_by => FND_GLOBAL.USER_ID,
12277: p_creation_date => sysdate);
12278:
12279: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12276: p_created_by => FND_GLOBAL.USER_ID,

12272: p_name => c_possetgrp_rec.name,
12273: p_last_update_date => sysdate,
12274: p_last_updated_by => FND_GLOBAL.USER_ID,
12275: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12276: p_created_by => FND_GLOBAL.USER_ID,
12277: p_creation_date => sysdate);
12278:
12279: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12280: raise FND_API.G_EXC_ERROR;

Line 12413: p_last_updated_by => FND_GLOBAL.USER_ID,

12409: p_account_or_position_type =>c_posset_rec.account_or_position_type,
12410: p_attribute_selection_type => c_posset_rec.attribute_selection_type,
12411: p_business_group_id => c_posset_rec.business_group_id,
12412: p_last_update_date => sysdate,
12413: p_last_updated_by => FND_GLOBAL.USER_ID,
12414: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12415: p_created_by => FND_GLOBAL.USER_ID,
12416: p_creation_date => sysdate);
12417:

Line 12414: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12410: p_attribute_selection_type => c_posset_rec.attribute_selection_type,
12411: p_business_group_id => c_posset_rec.business_group_id,
12412: p_last_update_date => sysdate,
12413: p_last_updated_by => FND_GLOBAL.USER_ID,
12414: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12415: p_created_by => FND_GLOBAL.USER_ID,
12416: p_creation_date => sysdate);
12417:
12418: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12415: p_created_by => FND_GLOBAL.USER_ID,

12411: p_business_group_id => c_posset_rec.business_group_id,
12412: p_last_update_date => sysdate,
12413: p_last_updated_by => FND_GLOBAL.USER_ID,
12414: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12415: p_created_by => FND_GLOBAL.USER_ID,
12416: p_creation_date => sysdate);
12417:
12418: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12419: raise FND_API.G_EXC_ERROR;

Line 12441: p_last_updated_by => FND_GLOBAL.USER_ID,

12437: p_account_or_position_type => c_posset_rec.account_or_position_type,
12438: p_attribute_selection_type =>c_posset_rec.attribute_selection_type,
12439: p_business_group_id => c_posset_rec.business_group_id,
12440: p_last_update_date => sysdate,
12441: p_last_updated_by => FND_GLOBAL.USER_ID,
12442: p_last_update_login => FND_GLOBAL.LOGIN_ID);
12443:
12444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12445: raise FND_API.G_EXC_ERROR;

Line 12442: p_last_update_login => FND_GLOBAL.LOGIN_ID);

12438: p_attribute_selection_type =>c_posset_rec.attribute_selection_type,
12439: p_business_group_id => c_posset_rec.business_group_id,
12440: p_last_update_date => sysdate,
12441: p_last_updated_by => FND_GLOBAL.USER_ID,
12442: p_last_update_login => FND_GLOBAL.LOGIN_ID);
12443:
12444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12445: raise FND_API.G_EXC_ERROR;
12446: end if;

Line 12483: p_last_updated_by => FND_GLOBAL.USER_ID,

12479: /* Budget Revision Rules Enhancement End */
12480: p_effective_start_date => null,
12481: p_effective_end_date => null,
12482: p_last_update_date => sysdate,
12483: p_last_updated_by => FND_GLOBAL.USER_ID,
12484: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12485: p_created_by => FND_GLOBAL.USER_ID,
12486: p_creation_date => sysdate);
12487:

Line 12484: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12480: p_effective_start_date => null,
12481: p_effective_end_date => null,
12482: p_last_update_date => sysdate,
12483: p_last_updated_by => FND_GLOBAL.USER_ID,
12484: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12485: p_created_by => FND_GLOBAL.USER_ID,
12486: p_creation_date => sysdate);
12487:
12488: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12485: p_created_by => FND_GLOBAL.USER_ID,

12481: p_effective_end_date => null,
12482: p_last_update_date => sysdate,
12483: p_last_updated_by => FND_GLOBAL.USER_ID,
12484: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12485: p_created_by => FND_GLOBAL.USER_ID,
12486: p_creation_date => sysdate);
12487:
12488: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12489: raise FND_API.G_EXC_ERROR;

Line 12682: p_last_updated_by => FND_GLOBAL.USER_ID,

12678: p_attribute8 => c_possetline_rec.attribute8,
12679: p_attribute9 => c_possetline_rec.attribute9,
12680: p_attribute10 => c_possetline_rec.attribute10,
12681: p_last_update_date => sysdate,
12682: p_last_updated_by => FND_GLOBAL.USER_ID,
12683: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12684: p_created_by => FND_GLOBAL.USER_ID,
12685: p_creation_date => sysdate);
12686:

Line 12683: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12679: p_attribute9 => c_possetline_rec.attribute9,
12680: p_attribute10 => c_possetline_rec.attribute10,
12681: p_last_update_date => sysdate,
12682: p_last_updated_by => FND_GLOBAL.USER_ID,
12683: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12684: p_created_by => FND_GLOBAL.USER_ID,
12685: p_creation_date => sysdate);
12686:
12687: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12684: p_created_by => FND_GLOBAL.USER_ID,

12680: p_attribute10 => c_possetline_rec.attribute10,
12681: p_last_update_date => sysdate,
12682: p_last_updated_by => FND_GLOBAL.USER_ID,
12683: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12684: p_created_by => FND_GLOBAL.USER_ID,
12685: p_creation_date => sysdate);
12686:
12687: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12688: raise FND_API.G_EXC_ERROR;

Line 12722: p_last_updated_by => FND_GLOBAL.USER_ID,

12718: p_line_sequence_id => l_line_sequence_id,
12719: p_attribute_value_id => l_attribute_value_id,
12720: p_attribute_value => c_possetlineval_rec.attribute_value,
12721: p_last_update_date => sysdate,
12722: p_last_updated_by => FND_GLOBAL.USER_ID,
12723: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12724: p_created_by => FND_GLOBAL.USER_ID,
12725: p_creation_date => sysdate);
12726:

Line 12723: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12719: p_attribute_value_id => l_attribute_value_id,
12720: p_attribute_value => c_possetlineval_rec.attribute_value,
12721: p_last_update_date => sysdate,
12722: p_last_updated_by => FND_GLOBAL.USER_ID,
12723: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12724: p_created_by => FND_GLOBAL.USER_ID,
12725: p_creation_date => sysdate);
12726:
12727: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12724: p_created_by => FND_GLOBAL.USER_ID,

12720: p_attribute_value => c_possetlineval_rec.attribute_value,
12721: p_last_update_date => sysdate,
12722: p_last_updated_by => FND_GLOBAL.USER_ID,
12723: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12724: p_created_by => FND_GLOBAL.USER_ID,
12725: p_creation_date => sysdate);
12726:
12727: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12728: raise FND_API.G_EXC_ERROR;

Line 12880: p_last_updated_by => FND_GLOBAL.USER_ID,

12876: p_segment28 => null,
12877: p_segment29 => null,
12878: p_segment30 => null,
12879: p_last_update_date => sysdate,
12880: p_last_updated_by => FND_GLOBAL.USER_ID,
12881: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12882: p_created_by => FND_GLOBAL.USER_ID,
12883: p_creation_date => sysdate);
12884:

Line 12881: p_last_update_login => FND_GLOBAL.LOGIN_ID,

12877: p_segment29 => null,
12878: p_segment30 => null,
12879: p_last_update_date => sysdate,
12880: p_last_updated_by => FND_GLOBAL.USER_ID,
12881: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12882: p_created_by => FND_GLOBAL.USER_ID,
12883: p_creation_date => sysdate);
12884:
12885: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 12882: p_created_by => FND_GLOBAL.USER_ID,

12878: p_segment30 => null,
12879: p_last_update_date => sysdate,
12880: p_last_updated_by => FND_GLOBAL.USER_ID,
12881: p_last_update_login => FND_GLOBAL.LOGIN_ID,
12882: p_created_by => FND_GLOBAL.USER_ID,
12883: p_creation_date => sysdate);
12884:
12885: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12886: raise FND_API.G_EXC_ERROR;

Line 12936: p_last_updated_by => FND_GLOBAL.USER_ID,

12932: p_segment28 => null,
12933: p_segment29 => null,
12934: p_segment30 => null,
12935: p_last_update_date => sysdate,
12936: p_last_updated_by => FND_GLOBAL.USER_ID,
12937: p_last_update_login => FND_GLOBAL.LOGIN_ID);
12938:
12939: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12940: raise FND_API.G_EXC_ERROR;

Line 12937: p_last_update_login => FND_GLOBAL.LOGIN_ID);

12933: p_segment29 => null,
12934: p_segment30 => null,
12935: p_last_update_date => sysdate,
12936: p_last_updated_by => FND_GLOBAL.USER_ID,
12937: p_last_update_login => FND_GLOBAL.LOGIN_ID);
12938:
12939: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
12940: raise FND_API.G_EXC_ERROR;
12941: end if;

Line 13017: p_last_updated_by => FND_GLOBAL.USER_ID,

13013: p_segment28 => c_elemdist_rec.segment28,
13014: p_segment29 => c_elemdist_rec.segment29,
13015: p_segment30 => c_elemdist_rec.segment30,
13016: p_last_update_date => sysdate,
13017: p_last_updated_by => FND_GLOBAL.USER_ID,
13018: p_last_update_login => FND_GLOBAL.LOGIN_ID,
13019: p_created_by => FND_GLOBAL.USER_ID,
13020: p_creation_date => sysdate);
13021:

Line 13018: p_last_update_login => FND_GLOBAL.LOGIN_ID,

13014: p_segment29 => c_elemdist_rec.segment29,
13015: p_segment30 => c_elemdist_rec.segment30,
13016: p_last_update_date => sysdate,
13017: p_last_updated_by => FND_GLOBAL.USER_ID,
13018: p_last_update_login => FND_GLOBAL.LOGIN_ID,
13019: p_created_by => FND_GLOBAL.USER_ID,
13020: p_creation_date => sysdate);
13021:
13022: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 13019: p_created_by => FND_GLOBAL.USER_ID,

13015: p_segment30 => c_elemdist_rec.segment30,
13016: p_last_update_date => sysdate,
13017: p_last_updated_by => FND_GLOBAL.USER_ID,
13018: p_last_update_login => FND_GLOBAL.LOGIN_ID,
13019: p_created_by => FND_GLOBAL.USER_ID,
13020: p_creation_date => sysdate);
13021:
13022: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13023: raise FND_API.G_EXC_ERROR;

Line 13074: p_last_updated_by => FND_GLOBAL.USER_ID,

13070: p_segment28 => c_elemdist_rec.segment28,
13071: p_segment29 => c_elemdist_rec.segment29,
13072: p_segment30 => c_elemdist_rec.segment30,
13073: p_last_update_date => sysdate,
13074: p_last_updated_by => FND_GLOBAL.USER_ID,
13075: p_last_update_login => FND_GLOBAL.LOGIN_ID);
13076:
13077: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13078: raise FND_API.G_EXC_ERROR;

Line 13075: p_last_update_login => FND_GLOBAL.LOGIN_ID);

13071: p_segment29 => c_elemdist_rec.segment29,
13072: p_segment30 => c_elemdist_rec.segment30,
13073: p_last_update_date => sysdate,
13074: p_last_updated_by => FND_GLOBAL.USER_ID,
13075: p_last_update_login => FND_GLOBAL.LOGIN_ID);
13076:
13077: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
13078: raise FND_API.G_EXC_ERROR;
13079: end if;