DBA Data[Home] [Help]

APPS.CN_SCA_INTERFACE_MAP_PVT dependencies on FND_GLOBAL

Line 373: l_user_id NUMBER(15) := fnd_global.user_id;

369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2)
372: IS
373: l_user_id NUMBER(15) := fnd_global.user_id;
374: l_login_id NUMBER(15) := fnd_global.login_id;
375: l_object_name VARCHAR2(80) := p_object_name;
376: l_line_length NUMBER;
377: l_send_position NUMBER;

Line 374: l_login_id NUMBER(15) := fnd_global.login_id;

370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2)
372: IS
373: l_user_id NUMBER(15) := fnd_global.user_id;
374: l_login_id NUMBER(15) := fnd_global.login_id;
375: l_object_name VARCHAR2(80) := p_object_name;
376: l_line_length NUMBER;
377: l_send_position NUMBER;
378: l_pkg_object_id NUMBER;

Line 528: l_user_id NUMBER(15) := fnd_global.user_id;

524: l_repository_id cn_repositories.repository_id%TYPE;
525:
526: l_api_name CONSTANT VARCHAR2(10) := 'MAP';
527: l_api_version CONSTANT NUMBER := 1.0;
528: l_user_id NUMBER(15) := fnd_global.user_id;
529: l_login_id NUMBER(15) := fnd_global.login_id;
530:
531: l_init_msg_list VARCHAR2(5) := fnd_api.g_false;
532: l_commit VARCHAR2(5) := fnd_api.g_false;

Line 529: l_login_id NUMBER(15) := fnd_global.login_id;

525:
526: l_api_name CONSTANT VARCHAR2(10) := 'MAP';
527: l_api_version CONSTANT NUMBER := 1.0;
528: l_user_id NUMBER(15) := fnd_global.user_id;
529: l_login_id NUMBER(15) := fnd_global.login_id;
530:
531: l_init_msg_list VARCHAR2(5) := fnd_api.g_false;
532: l_commit VARCHAR2(5) := fnd_api.g_false;
533: l_validation_level NUMBER := fnd_api.g_valid_level_full;

Line 928: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');

924: cn_utils.appendcr(l_body_code,' x_msg_count OUT NOCOPY NUMBER,');
925: cn_utils.appendcr(l_body_code,' x_msg_data OUT NOCOPY VARCHAR2)');
926: cn_utils.appendcr(l_body_code,' IS');
927: cn_utils.appendcr(l_body_code,' l_api_name CONSTANT VARCHAR2(30) := ''check_update_revenue_error'';');
928: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');
929: cn_utils.appendcr(l_body_code,' l_adj_by VARCHAR(100);');
930:
931: cn_utils.appendcr(l_body_code,' CURSOR sca_reset_ord_err_cur');
932: cn_utils.appendcr(l_body_code,' IS');

Line 1078: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');

1074: cn_utils.appendcr(l_body_code,' x_msg_count OUT NOCOPY NUMBER,');
1075: cn_utils.appendcr(l_body_code,' x_msg_data OUT NOCOPY VARCHAR2)');
1076: cn_utils.appendcr(l_body_code,' IS');
1077: cn_utils.appendcr(l_body_code,' l_api_name CONSTANT VARCHAR2(30) := ''check_update_revenue_error'';');
1078: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');
1079:
1080: cn_utils.appendcr(l_body_code,' CURSOR rev_typ_all_ord_cur');
1081: cn_utils.appendcr(l_body_code,' IS');
1082: cn_utils.appendcr(l_body_code,' SELECT comm_lines_api_id');

Line 1271: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');

1267: cn_utils.appendcr(l_body_code,' x_msg_count OUT NOCOPY NUMBER,');
1268: cn_utils.appendcr(l_body_code,' x_msg_data OUT NOCOPY VARCHAR2)');
1269: cn_utils.appendcr(l_body_code,' IS');
1270: cn_utils.appendcr(l_body_code,' l_api_name CONSTANT VARCHAR2(30) := ''check_update_role_error'';');
1271: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');
1272:
1273: cn_utils.appendcr(l_body_code,' TYPE ccla_id_tbl IS');
1274: cn_utils.appendcr(l_body_code,' TABLE OF cn_comm_lines_api.comm_lines_api_id%TYPE');
1275: cn_utils.appendcr(l_body_code,' INDEX BY BINARY_INTEGER;');

Line 1443: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');

1439: cn_utils.appendcr(l_body_code,' x_msg_count OUT NOCOPY NUMBER,');
1440: cn_utils.appendcr(l_body_code,' x_msg_data OUT NOCOPY VARCHAR2)');
1441: cn_utils.appendcr(l_body_code,' IS');
1442: cn_utils.appendcr(l_body_code,' l_api_name CONSTANT VARCHAR2(50) := ''check_update_resource_error'';');
1443: cn_utils.appendcr(l_body_code,' l_user_id NUMBER := fnd_global.user_id;');
1444:
1445: cn_utils.appendcr(l_body_code,' TYPE ccla_id_tbl IS');
1446: cn_utils.appendcr(l_body_code,' TABLE OF cn_comm_lines_api.comm_lines_api_id%TYPE');
1447: cn_utils.appendcr(l_body_code,' INDEX BY BINARY_INTEGER;');

Line 1754: cn_utils.appendcr(l_body_code,' l_user_id NUMBER(15) := fnd_global.user_id;');

1750:
1751: cn_utils.appendcr(l_body_code,'------+');
1752: cn_utils.appendcr(l_body_code,'-- To Store values to update WHO Columns');
1753: cn_utils.appendcr(l_body_code,'------+');
1754: cn_utils.appendcr(l_body_code,' l_user_id NUMBER(15) := fnd_global.user_id;');
1755: cn_utils.appendcr(l_body_code,' l_login_id NUMBER(15) := fnd_global.login_id;');
1756:
1757: cn_utils.appendcr(l_body_code,'------+');
1758: cn_utils.appendcr(l_body_code,'-- To store values for start_id and end_id of CN_SCA_PROCESS_BATCHES');

Line 1755: cn_utils.appendcr(l_body_code,' l_login_id NUMBER(15) := fnd_global.login_id;');

1751: cn_utils.appendcr(l_body_code,'------+');
1752: cn_utils.appendcr(l_body_code,'-- To Store values to update WHO Columns');
1753: cn_utils.appendcr(l_body_code,'------+');
1754: cn_utils.appendcr(l_body_code,' l_user_id NUMBER(15) := fnd_global.user_id;');
1755: cn_utils.appendcr(l_body_code,' l_login_id NUMBER(15) := fnd_global.login_id;');
1756:
1757: cn_utils.appendcr(l_body_code,'------+');
1758: cn_utils.appendcr(l_body_code,'-- To store values for start_id and end_id of CN_SCA_PROCESS_BATCHES');
1759: cn_utils.appendcr(l_body_code,'------+');