APPS.CN_SRP_PRD_QUOTA_PUB dependencies on FND_GLOBAL

Line 57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

53: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
54: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
55:
56: G_LAST_UPDATE_DATE DATE := sysdate;
57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
58: G_CREATION_DATE DATE := sysdate;
59: G_CREATED_BY NUMBER := fnd_global.user_id;
60: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
61:

Line 59: G_CREATED_BY NUMBER := fnd_global.user_id;

55:
56: G_LAST_UPDATE_DATE DATE := sysdate;
57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
58: G_CREATION_DATE DATE := sysdate;
59: G_CREATED_BY NUMBER := fnd_global.user_id;
60: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
61:
62: G_ROWID VARCHAR2(30);
63: G_PROGRAM_TYPE VARCHAR2(30);

Line 60: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

56: G_LAST_UPDATE_DATE DATE := sysdate;
57: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
58: G_CREATION_DATE DATE := sysdate;
59: G_CREATED_BY NUMBER := fnd_global.user_id;
60: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
61:
62: G_ROWID VARCHAR2(30);
63: G_PROGRAM_TYPE VARCHAR2(30);
64:

Line 532: ,x_created_by => fnd_global.user_id

528: ,x_salesrep_id => l_salesrep_id
529: ,x_end_date => NULL
530: ,x_commission_payed_ptd => l_commission_payed_ptd
531: ,x_creation_date => sysdate
532: ,x_created_by => fnd_global.user_id
533: ,x_last_update_date => sysdate
534: ,x_last_updated_by => fnd_global.user_id
535: ,x_last_update_login => fnd_global.login_id);
536:

Line 534: ,x_last_updated_by => fnd_global.user_id

530: ,x_commission_payed_ptd => l_commission_payed_ptd
531: ,x_creation_date => sysdate
532: ,x_created_by => fnd_global.user_id
533: ,x_last_update_date => sysdate
534: ,x_last_updated_by => fnd_global.user_id
535: ,x_last_update_login => fnd_global.login_id);
536:
537: END LOOP;
538:

Line 535: ,x_last_update_login => fnd_global.login_id);

531: ,x_creation_date => sysdate
532: ,x_created_by => fnd_global.user_id
533: ,x_last_update_date => sysdate
534: ,x_last_updated_by => fnd_global.user_id
535: ,x_last_update_login => fnd_global.login_id);
536:
537: END LOOP;
538:
539: END IF; --IF p_srp_prd_quota_tbl%COUNT > 0