DBA Data[Home] [Help]

APPS.CN_PREPOST_PVT dependencies on FND_GLOBAL

Line 326: FND_GLOBAL.USER_ID created_by,

322: FND_API.G_MISS_DATE loaded_date,
323: cl.pending_status,
324: cl.status cl_status,
325: cl.created_during,
326: FND_GLOBAL.USER_ID created_by,
327: SYSDATE creation_date,
328: FND_GLOBAL.LOGIN_ID last_update_login,
329: SYSDATE last_update_date,
330: FND_GLOBAL.USER_ID last_updated_by*/

Line 328: FND_GLOBAL.LOGIN_ID last_update_login,

324: cl.status cl_status,
325: cl.created_during,
326: FND_GLOBAL.USER_ID created_by,
327: SYSDATE creation_date,
328: FND_GLOBAL.LOGIN_ID last_update_login,
329: SYSDATE last_update_date,
330: FND_GLOBAL.USER_ID last_updated_by*/
331: FROM cn_commission_lines_all cl,
332: -- cn_srp_plan_assigns srcp,

Line 330: FND_GLOBAL.USER_ID last_updated_by*/

326: FND_GLOBAL.USER_ID created_by,
327: SYSDATE creation_date,
328: FND_GLOBAL.LOGIN_ID last_update_login,
329: SYSDATE last_update_date,
330: FND_GLOBAL.USER_ID last_updated_by*/
331: FROM cn_commission_lines_all cl,
332: -- cn_srp_plan_assigns srcp,
333: --cn_srp_payee_assigns srpa, removed for payee assigns bug #2495614
334: -- cn_role_plans rcp,

Line 846: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

842: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
843: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
844: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
845: l_pdet_rec_tbl(i).creation_date := SYSDATE;
846: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
847: l_status := 'COMM Non Rec '||TO_CHAR(i)||' built';
848: i := i + 1;
849: END IF;
850:

Line 867: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

863: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
864: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
865: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
866: l_pdet_rec_tbl(i).creation_date := SYSDATE;
867: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
868: l_status := 'COMM Rec '||TO_CHAR(i)||' built';
869: i := i + 1;
870: END IF;
871:

Line 888: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

884: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
885: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
886: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
887: l_pdet_rec_tbl(i).creation_date := SYSDATE;
888: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
889: l_status := 'COMM To Recover '||TO_CHAR(i)||' built';
890: i := i + 1;
891: END IF;
892:

Line 909: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

905: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
906: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
907: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
908: l_pdet_rec_tbl(i).creation_date := SYSDATE;
909: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
910: l_status := 'BONUS Rec '||TO_CHAR(i)||' built';
911: i := i + 1;
912: END IF;
913:

Line 930: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

926: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
927: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
928: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
929: l_pdet_rec_tbl(i).creation_date := SYSDATE;
930: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
931: l_status := 'BONUS To Rec '||TO_CHAR(i)||' built';
932: i := i + 1;
933: END IF;
934:

Line 957: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;

953: l_pdet_rec_tbl(i).role_id := l_pay_ws_rec.role_id;
954: l_pdet_rec_tbl(i).credit_type_id := l_pay_ws_rec.credit_type_id;
955: l_pdet_rec_tbl(i).pay_period_id := l_pay_ws_rec.pay_period_id;
956: l_pdet_rec_tbl(i).creation_date := SYSDATE;
957: l_pdet_rec_tbl(i).created_by := FND_GLOBAL.USER_ID;
958: l_status := 'MANUAL Expense '||TO_CHAR(i)||' built';
959: i := i + 1;
960: END IF;
961: END LOOP;

Line 993: x_last_updated_by => FND_GLOBAL.USER_ID,

989: (
990: x_payment_worksheet_id => l_pay_ws_rec.payment_worksheet_id,
991: x_posting_status => c_posted,
992: x_last_update_date => SYSDATE,
993: x_last_updated_by => FND_GLOBAL.USER_ID,
994: x_last_update_login => FND_GLOBAL.LOGIN_ID);
995:
996:
997: l_status := 'Posting Detail created for WS';

Line 994: x_last_update_login => FND_GLOBAL.LOGIN_ID);

990: x_payment_worksheet_id => l_pay_ws_rec.payment_worksheet_id,
991: x_posting_status => c_posted,
992: x_last_update_date => SYSDATE,
993: x_last_updated_by => FND_GLOBAL.USER_ID,
994: x_last_update_login => FND_GLOBAL.LOGIN_ID);
995:
996:
997: l_status := 'Posting Detail created for WS';
998:

Line 1025: x_last_updated_by => FND_GLOBAL.USER_ID,

1021: null;
1022: /*
1023: cn_payruns_pkg.update_record(x_payrun_id => l_posted_payrun.payrun_id,
1024: x_status => C_POSTED,
1025: x_last_updated_by => FND_GLOBAL.USER_ID,
1026: x_last_update_date => SYSDATE,
1027: x_last_update_login => FND_GLOBAL.LOGIN_ID);
1028: */
1029: end loop;

Line 1027: x_last_update_login => FND_GLOBAL.LOGIN_ID);

1023: cn_payruns_pkg.update_record(x_payrun_id => l_posted_payrun.payrun_id,
1024: x_status => C_POSTED,
1025: x_last_updated_by => FND_GLOBAL.USER_ID,
1026: x_last_update_date => SYSDATE,
1027: x_last_update_login => FND_GLOBAL.LOGIN_ID);
1028: */
1029: end loop;
1030:
1031: -- End of API body.