DBA Data[Home] [Help]

APPS.CN_PRD_QUOTA_PUB dependencies on FND_GLOBAL

Line 163: x_last_update_login => fnd_global.login_id,

159: x_quarter_num => pq_rec.quarter_num,
160: x_period_year => pq_rec.period_year,
161: x_creation_date => SYSDATE,
162: x_last_update_date => SYSDATE,
163: x_last_update_login => fnd_global.login_id,
164: x_last_updated_by => fnd_global.user_id,
165: x_created_by => fnd_global.user_id,
166: x_period_type_code => 'PERIOD',
167: x_performance_goal => NVL (l_period_performance_goal, 0)

Line 164: x_last_updated_by => fnd_global.user_id,

160: x_period_year => pq_rec.period_year,
161: x_creation_date => SYSDATE,
162: x_last_update_date => SYSDATE,
163: x_last_update_login => fnd_global.login_id,
164: x_last_updated_by => fnd_global.user_id,
165: x_created_by => fnd_global.user_id,
166: x_period_type_code => 'PERIOD',
167: x_performance_goal => NVL (l_period_performance_goal, 0)
168: );

Line 165: x_created_by => fnd_global.user_id,

161: x_creation_date => SYSDATE,
162: x_last_update_date => SYSDATE,
163: x_last_update_login => fnd_global.login_id,
164: x_last_updated_by => fnd_global.user_id,
165: x_created_by => fnd_global.user_id,
166: x_period_type_code => 'PERIOD',
167: x_performance_goal => NVL (l_period_performance_goal, 0)
168: );
169: END LOOP;

Line 244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

240: f_fixed_amount CN_QUOTAS.payment_amount%TYPE;
241: f_performance_goal CN_QUOTAS.performance_goal%TYPE;
242:
243: G_LAST_UPDATE_DATE DATE := sysdate;
244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
245: G_CREATION_DATE DATE := sysdate;
246: G_CREATED_BY NUMBER := fnd_global.user_id;
247: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
248:

Line 246: G_CREATED_BY NUMBER := fnd_global.user_id;

242:
243: G_LAST_UPDATE_DATE DATE := sysdate;
244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
245: G_CREATION_DATE DATE := sysdate;
246: G_CREATED_BY NUMBER := fnd_global.user_id;
247: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
248:
249: G_ROWID VARCHAR2(30);
250: G_PROGRAM_TYPE VARCHAR2(30);

Line 247: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

243: G_LAST_UPDATE_DATE DATE := sysdate;
244: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
245: G_CREATION_DATE DATE := sysdate;
246: G_CREATED_BY NUMBER := fnd_global.user_id;
247: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
248:
249: G_ROWID VARCHAR2(30);
250: G_PROGRAM_TYPE VARCHAR2(30);
251:

Line 716: x_last_update_login => fnd_global.login_id,

712: x_quarter_num => tbl_quarter_num,
713: x_period_year => tbl_period_year,
714: x_creation_date => sysdate,
715: x_last_update_date => sysdate,
716: x_last_update_login => fnd_global.login_id,
717: x_last_updated_by => fnd_global.user_id,
718: x_created_by => fnd_global.user_id,
719: x_period_type_code => 'PERIOD',
720: x_performance_goal => p_prd_quota_tbl(i).PERFORMANCE_GOAL);

Line 717: x_last_updated_by => fnd_global.user_id,

713: x_period_year => tbl_period_year,
714: x_creation_date => sysdate,
715: x_last_update_date => sysdate,
716: x_last_update_login => fnd_global.login_id,
717: x_last_updated_by => fnd_global.user_id,
718: x_created_by => fnd_global.user_id,
719: x_period_type_code => 'PERIOD',
720: x_performance_goal => p_prd_quota_tbl(i).PERFORMANCE_GOAL);
721:

Line 718: x_created_by => fnd_global.user_id,

714: x_creation_date => sysdate,
715: x_last_update_date => sysdate,
716: x_last_update_login => fnd_global.login_id,
717: x_last_updated_by => fnd_global.user_id,
718: x_created_by => fnd_global.user_id,
719: x_period_type_code => 'PERIOD',
720: x_performance_goal => p_prd_quota_tbl(i).PERFORMANCE_GOAL);
721:
722: