APPS.CN_SRP_PERIODS_PVT dependencies on FND_GLOBAL

Line 593: ,x_created_by => FND_GLOBAL.USER_ID

589: ,x_srp_plan_assign_id => l_srp_plan_assign_id
590: ,x_role_id => p_role_id
591: ,x_quota_id => l_quota_csr.quota_id
592: ,x_pay_group_id => l_srp_pay_grp_csr.pay_group_id
593: ,x_created_by => FND_GLOBAL.USER_ID
594: ,x_creation_date => SYSDATE
595: ,x_last_update_date => SYSDATE
596: ,x_last_updated_by => FND_GLOBAL.USER_ID
597: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

Line 596: ,x_last_updated_by => FND_GLOBAL.USER_ID

592: ,x_pay_group_id => l_srp_pay_grp_csr.pay_group_id
593: ,x_created_by => FND_GLOBAL.USER_ID
594: ,x_creation_date => SYSDATE
595: ,x_last_update_date => SYSDATE
596: ,x_last_updated_by => FND_GLOBAL.USER_ID
597: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
598: );
599: ELSE
600: -- records exist - update plan assign ID

Line 597: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

593: ,x_created_by => FND_GLOBAL.USER_ID
594: ,x_creation_date => SYSDATE
595: ,x_last_update_date => SYSDATE
596: ,x_last_updated_by => FND_GLOBAL.USER_ID
597: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
598: );
599: ELSE
600: -- records exist - update plan assign ID
601: update cn_srp_periods_all

Line 655: ,x_created_by => FND_GLOBAL.USER_ID

651: ,x_srp_plan_assign_id => null
652: ,x_role_id => null
653: ,x_quota_id => null
654: ,x_pay_group_id => null
655: ,x_created_by => FND_GLOBAL.USER_ID
656: ,x_creation_date => SYSDATE
657: ,x_last_update_date => SYSDATE
658: ,x_last_updated_by => FND_GLOBAL.USER_ID
659: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

Line 658: ,x_last_updated_by => FND_GLOBAL.USER_ID

654: ,x_pay_group_id => null
655: ,x_created_by => FND_GLOBAL.USER_ID
656: ,x_creation_date => SYSDATE
657: ,x_last_update_date => SYSDATE
658: ,x_last_updated_by => FND_GLOBAL.USER_ID
659: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
660: );
661: end loop; -- periods
662:

Line 659: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

655: ,x_created_by => FND_GLOBAL.USER_ID
656: ,x_creation_date => SYSDATE
657: ,x_last_update_date => SYSDATE
658: ,x_last_updated_by => FND_GLOBAL.USER_ID
659: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
660: );
661: end loop; -- periods
662:
663: for p in get_carry_pds(ct.credit_type_id) loop

Line 676: ,x_created_by => FND_GLOBAL.USER_ID

672: ,x_srp_plan_assign_id => -1
673: ,x_role_id => -1
674: ,x_quota_id => -1000
675: ,x_pay_group_id => -1
676: ,x_created_by => FND_GLOBAL.USER_ID
677: ,x_creation_date => SYSDATE
678: ,x_last_update_date => SYSDATE
679: ,x_last_updated_by => FND_GLOBAL.USER_ID
680: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

Line 679: ,x_last_updated_by => FND_GLOBAL.USER_ID

675: ,x_pay_group_id => -1
676: ,x_created_by => FND_GLOBAL.USER_ID
677: ,x_creation_date => SYSDATE
678: ,x_last_update_date => SYSDATE
679: ,x_last_updated_by => FND_GLOBAL.USER_ID
680: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
681: );
682: end loop; -- periods
683:

Line 680: ,x_last_update_login => FND_GLOBAL.LOGIN_ID

676: ,x_created_by => FND_GLOBAL.USER_ID
677: ,x_creation_date => SYSDATE
678: ,x_last_update_date => SYSDATE
679: ,x_last_updated_by => FND_GLOBAL.USER_ID
680: ,x_last_update_login => FND_GLOBAL.LOGIN_ID
681: );
682: end loop; -- periods
683:
684: -- populate begin balance columns and summary records