DBA Data[Home] [Help]

APPS.CSI_COUNTER_PVT dependencies on FND_GLOBAL

Line 1089: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1085: ,p_START_DATE_ACTIVE => l_start_date_active
1086: ,p_END_DATE_ACTIVE => l_end_date_active
1087: ,p_OBJECT_VERSION_NUMBER => 1
1088: ,p_LAST_UPDATE_DATE => sysdate
1089: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1090: ,p_CREATION_DATE => sysdate
1091: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1092: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1093: ,p_ATTRIBUTE1 => l_attribute1

Line 1091: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1087: ,p_OBJECT_VERSION_NUMBER => 1
1088: ,p_LAST_UPDATE_DATE => sysdate
1089: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1090: ,p_CREATION_DATE => sysdate
1091: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1092: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1093: ,p_ATTRIBUTE1 => l_attribute1
1094: ,p_ATTRIBUTE2 => l_attribute2
1095: ,p_ATTRIBUTE3 => l_attribute3

Line 1092: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID

1088: ,p_LAST_UPDATE_DATE => sysdate
1089: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1090: ,p_CREATION_DATE => sysdate
1091: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1092: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1093: ,p_ATTRIBUTE1 => l_attribute1
1094: ,p_ATTRIBUTE2 => l_attribute2
1095: ,p_ATTRIBUTE3 => l_attribute3
1096: ,p_ATTRIBUTE4 => l_attribute4

Line 1511: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1507: ,p_END_DATE_ACTIVE => l_end_date_active
1508: ,p_OBJECT_VERSION_NUMBER => 1
1509: ,p_SECURITY_GROUP_ID => null
1510: ,p_LAST_UPDATE_DATE => sysdate
1511: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1512: ,p_CREATION_DATE => sysdate
1513: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1515: ,p_ATTRIBUTE1 => l_attribute1

Line 1513: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1509: ,p_SECURITY_GROUP_ID => null
1510: ,p_LAST_UPDATE_DATE => sysdate
1511: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1512: ,p_CREATION_DATE => sysdate
1513: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1515: ,p_ATTRIBUTE1 => l_attribute1
1516: ,p_ATTRIBUTE2 => l_attribute2
1517: ,p_ATTRIBUTE3 => l_attribute3

Line 1514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID

1510: ,p_LAST_UPDATE_DATE => sysdate
1511: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1512: ,p_CREATION_DATE => sysdate
1513: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1514: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1515: ,p_ATTRIBUTE1 => l_attribute1
1516: ,p_ATTRIBUTE2 => l_attribute2
1517: ,p_ATTRIBUTE3 => l_attribute3
1518: ,p_ATTRIBUTE4 => l_attribute4

Line 1903: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1899: ,p_START_DATE_ACTIVE => l_start_date_active
1900: ,p_END_DATE_ACTIVE => l_end_date_active
1901: ,p_OBJECT_VERSION_NUMBER => 1
1902: ,p_LAST_UPDATE_DATE => sysdate
1903: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1904: ,p_CREATION_DATE => sysdate
1905: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1906: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1907: ,p_ATTRIBUTE1 => l_attribute1

Line 1905: ,p_CREATED_BY => FND_GLOBAL.USER_ID

1901: ,p_OBJECT_VERSION_NUMBER => 1
1902: ,p_LAST_UPDATE_DATE => sysdate
1903: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1904: ,p_CREATION_DATE => sysdate
1905: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1906: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1907: ,p_ATTRIBUTE1 => l_attribute1
1908: ,p_ATTRIBUTE2 => l_attribute2
1909: ,p_ATTRIBUTE3 => l_attribute3

Line 1906: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID

1902: ,p_LAST_UPDATE_DATE => sysdate
1903: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1904: ,p_CREATION_DATE => sysdate
1905: ,p_CREATED_BY => FND_GLOBAL.USER_ID
1906: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
1907: ,p_ATTRIBUTE1 => l_attribute1
1908: ,p_ATTRIBUTE2 => l_attribute2
1909: ,p_ATTRIBUTE3 => l_attribute3
1910: ,p_ATTRIBUTE4 => l_attribute4

Line 2175: ,p_last_updated_by => FND_GLOBAL.USER_ID

2171: --,p_active_start_date => l_active_start_date
2172: --,p_active_end_date => l_active_end_date
2173: ,p_object_version_number => 1
2174: ,p_last_update_date => sysdate
2175: ,p_last_updated_by => FND_GLOBAL.USER_ID
2176: ,p_creation_date => sysdate
2177: ,p_created_by => FND_GLOBAL.USER_ID
2178: ,p_last_update_login => FND_GLOBAL.USER_ID
2179: ,p_SOURCE_GROUP_REF_ID => l_source_group_ref_id

Line 2177: ,p_created_by => FND_GLOBAL.USER_ID

2173: ,p_object_version_number => 1
2174: ,p_last_update_date => sysdate
2175: ,p_last_updated_by => FND_GLOBAL.USER_ID
2176: ,p_creation_date => sysdate
2177: ,p_created_by => FND_GLOBAL.USER_ID
2178: ,p_last_update_login => FND_GLOBAL.USER_ID
2179: ,p_SOURCE_GROUP_REF_ID => l_source_group_ref_id
2180: ,p_SOURCE_GROUP_REF => l_source_group_ref
2181: ,p_SOURCE_HEADER_REF_ID => l_source_header_ref_id

Line 2178: ,p_last_update_login => FND_GLOBAL.USER_ID

2174: ,p_last_update_date => sysdate
2175: ,p_last_updated_by => FND_GLOBAL.USER_ID
2176: ,p_creation_date => sysdate
2177: ,p_created_by => FND_GLOBAL.USER_ID
2178: ,p_last_update_login => FND_GLOBAL.USER_ID
2179: ,p_SOURCE_GROUP_REF_ID => l_source_group_ref_id
2180: ,p_SOURCE_GROUP_REF => l_source_group_ref
2181: ,p_SOURCE_HEADER_REF_ID => l_source_header_ref_id
2182: ,p_SOURCE_HEADER_REF => l_source_header_ref

Line 2407: ,p_last_updated_by => FND_GLOBAL.USER_ID

2403: ,p_active_start_date => l_active_start_date
2404: ,p_active_end_date => l_active_end_date
2405: ,p_object_version_number => 1
2406: ,p_last_update_date => sysdate
2407: ,p_last_updated_by => FND_GLOBAL.USER_ID
2408: ,p_creation_date => sysdate
2409: ,p_created_by => FND_GLOBAL.USER_ID
2410: ,p_last_update_login => FND_GLOBAL.USER_ID
2411: );

Line 2409: ,p_created_by => FND_GLOBAL.USER_ID

2405: ,p_object_version_number => 1
2406: ,p_last_update_date => sysdate
2407: ,p_last_updated_by => FND_GLOBAL.USER_ID
2408: ,p_creation_date => sysdate
2409: ,p_created_by => FND_GLOBAL.USER_ID
2410: ,p_last_update_login => FND_GLOBAL.USER_ID
2411: );
2412: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2413: ROLLBACK TO create_daily_usage_pvt;

Line 2410: ,p_last_update_login => FND_GLOBAL.USER_ID

2406: ,p_last_update_date => sysdate
2407: ,p_last_updated_by => FND_GLOBAL.USER_ID
2408: ,p_creation_date => sysdate
2409: ,p_created_by => FND_GLOBAL.USER_ID
2410: ,p_last_update_login => FND_GLOBAL.USER_ID
2411: );
2412: IF NOT (x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2413: ROLLBACK TO create_daily_usage_pvt;
2414: RETURN;

Line 3194: ,p_last_updated_by => FND_GLOBAL.USER_ID

3190: ,p_start_date_active => p_counter_instance_rec.start_date_active
3191: ,p_end_date_active => p_counter_instance_rec.end_date_active
3192: ,p_object_version_number => p_counter_instance_rec.object_version_number + 1
3193: ,p_last_update_date => sysdate
3194: ,p_last_updated_by => FND_GLOBAL.USER_ID
3195: ,p_creation_date => p_counter_instance_rec.creation_date
3196: ,p_created_by => p_counter_instance_rec.created_by
3197: ,p_last_update_login => FND_GLOBAL.USER_ID
3198: ,p_attribute1 => p_counter_instance_rec.attribute1

Line 3197: ,p_last_update_login => FND_GLOBAL.USER_ID

3193: ,p_last_update_date => sysdate
3194: ,p_last_updated_by => FND_GLOBAL.USER_ID
3195: ,p_creation_date => p_counter_instance_rec.creation_date
3196: ,p_created_by => p_counter_instance_rec.created_by
3197: ,p_last_update_login => FND_GLOBAL.USER_ID
3198: ,p_attribute1 => p_counter_instance_rec.attribute1
3199: ,p_attribute2 => p_counter_instance_rec.attribute2
3200: ,p_attribute3 => p_counter_instance_rec.attribute3
3201: ,p_attribute4 => p_counter_instance_rec.attribute4

Line 3660: ,p_last_updated_by => FND_GLOBAL.USER_ID

3656: ,p_end_date_active => p_ctr_properties_rec.end_date_active
3657: ,p_object_version_number => p_ctr_properties_rec.object_version_number + 1
3658: ,p_SECURITY_GROUP_ID => null
3659: ,p_last_update_date => sysdate
3660: ,p_last_updated_by => FND_GLOBAL.USER_ID
3661: ,p_creation_date => p_ctr_properties_rec.creation_date
3662: ,p_created_by => p_ctr_properties_rec.created_by
3663: ,p_last_update_login => FND_GLOBAL.USER_ID
3664: ,p_attribute1 => p_ctr_properties_rec.attribute1

Line 3663: ,p_last_update_login => FND_GLOBAL.USER_ID

3659: ,p_last_update_date => sysdate
3660: ,p_last_updated_by => FND_GLOBAL.USER_ID
3661: ,p_creation_date => p_ctr_properties_rec.creation_date
3662: ,p_created_by => p_ctr_properties_rec.created_by
3663: ,p_last_update_login => FND_GLOBAL.USER_ID
3664: ,p_attribute1 => p_ctr_properties_rec.attribute1
3665: ,p_attribute2 => p_ctr_properties_rec.attribute2
3666: ,p_attribute3 => p_ctr_properties_rec.attribute3
3667: ,p_attribute4 => p_ctr_properties_rec.attribute4

Line 4017: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

4013: ,p_SOURCE_OBJECT_CODE => p_counter_associations_rec.SOURCE_OBJECT_CODE
4014: ,p_SOURCE_OBJECT_ID => p_counter_associations_rec.SOURCE_OBJECT_ID
4015: ,p_OBJECT_VERSION_NUMBER => p_counter_associations_rec.OBJECT_VERSION_NUMBER + 1
4016: ,p_LAST_UPDATE_DATE => sysdate
4017: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
4018: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
4019: ,p_CREATION_DATE => p_counter_associations_rec.CREATION_DATE
4020: ,p_CREATED_BY => p_counter_associations_rec.CREATED_BY
4021: ,p_ATTRIBUTE1 => p_counter_associations_rec.ATTRIBUTE1

Line 4018: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID

4014: ,p_SOURCE_OBJECT_ID => p_counter_associations_rec.SOURCE_OBJECT_ID
4015: ,p_OBJECT_VERSION_NUMBER => p_counter_associations_rec.OBJECT_VERSION_NUMBER + 1
4016: ,p_LAST_UPDATE_DATE => sysdate
4017: ,p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
4018: ,p_LAST_UPDATE_LOGIN => FND_GLOBAL.USER_ID
4019: ,p_CREATION_DATE => p_counter_associations_rec.CREATION_DATE
4020: ,p_CREATED_BY => p_counter_associations_rec.CREATED_BY
4021: ,p_ATTRIBUTE1 => p_counter_associations_rec.ATTRIBUTE1
4022: ,p_ATTRIBUTE2 => p_counter_associations_rec.ATTRIBUTE2

Line 4255: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

4251: IF NVL(px_ctr_val_max_seq_no, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4252:
4253: UPDATE CSI_COUNTERS_B SET CTR_VAL_MAX_SEQ_NO = px_ctr_val_max_seq_no,
4254: OBJECT_VERSION_NUMBER = l_old_object_version_number + 1,
4255: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4256: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4257: WHERE COUNTER_ID = p_counter_id;
4258:
4259: END IF;

Line 4256: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

4252:
4253: UPDATE CSI_COUNTERS_B SET CTR_VAL_MAX_SEQ_NO = px_ctr_val_max_seq_no,
4254: OBJECT_VERSION_NUMBER = l_old_object_version_number + 1,
4255: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4256: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4257: WHERE COUNTER_ID = p_counter_id;
4258:
4259: END IF;
4260: /*CSI_COUNTERS_PKG.update_row

Line 4284: ,p_last_updated_by => FND_GLOBAL.USER_ID

4280: ,p_start_date_active => NULL
4281: ,p_end_date_active => NULL
4282: ,p_object_version_number => l_old_object_version_number + 1
4283: ,p_last_update_date => SYSDATE
4284: ,p_last_updated_by => FND_GLOBAL.USER_ID
4285: ,p_creation_date => NULL
4286: ,p_created_by => NULL
4287: ,p_last_update_login => FND_GLOBAL.USER_ID
4288: ,p_attribute1 => NULL

Line 4287: ,p_last_update_login => FND_GLOBAL.USER_ID

4283: ,p_last_update_date => SYSDATE
4284: ,p_last_updated_by => FND_GLOBAL.USER_ID
4285: ,p_creation_date => NULL
4286: ,p_created_by => NULL
4287: ,p_last_update_login => FND_GLOBAL.USER_ID
4288: ,p_attribute1 => NULL
4289: ,p_attribute2 => NULL
4290: ,p_attribute3 => NULL
4291: ,p_attribute4 => NULL