APPS.CN_TABLE_MAPS_PVT dependencies on FND_GLOBAL

Line 6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

2: /* $Header: cnvtmapb.pls 120.8 2006/01/11 23:53:52 apink noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TABLE_MAPS_PVT';
5: G_LAST_UPDATE_DATE DATE := SYSDATE;
6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
7: G_CREATION_DATE DATE := SYSDATE;
8: G_CREATED_BY NUMBER := fnd_global.user_id;
9: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
10:

Line 8: G_CREATED_BY NUMBER := fnd_global.user_id;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_TABLE_MAPS_PVT';
5: G_LAST_UPDATE_DATE DATE := SYSDATE;
6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
7: G_CREATION_DATE DATE := SYSDATE;
8: G_CREATED_BY NUMBER := fnd_global.user_id;
9: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
10:
11: -----------------------------------------------------------------------------+
12: -- Procedure : Create_Map

Line 9: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

5: G_LAST_UPDATE_DATE DATE := SYSDATE;
6: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
7: G_CREATION_DATE DATE := SYSDATE;
8: G_CREATED_BY NUMBER := fnd_global.user_id;
9: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
10:
11: -----------------------------------------------------------------------------+
12: -- Procedure : Create_Map
13: -----------------------------------------------------------------------------+

Line 1239: x_notify_from := x_notify_from||','||fnd_global.local_chr(10)||l_c1_rec.hdr_tab_name||

1235: --+
1236: -- Add the Header Table to the Notify_From table list and add
1237: -- the join to it into the Notify_Where clause
1238: --+
1239: x_notify_from := x_notify_from||','||fnd_global.local_chr(10)||l_c1_rec.hdr_tab_name||
1240: ' '||l_c1_rec.hdr_tab_alias;
1241: x_notify_where := l_c1_rec.hdr_tab_alias||'.'||l_c1_rec.hdr_pk_col||' = '||
1242: l_c1_rec.line_tab_alias||'.'||l_c1_rec.line_fk_col;
1243: END IF;

Line 1262: x_collect_from := x_collect_from||fnd_global.local_chr(10)||rec.name||',';

1258: AND tmobj.tm_object_type = 'COLLTAB'
1259: AND obj.object_id = tmobj.object_id
1260: AND obj.org_id = p_org_id AND obj.org_id = tmobj.org_id)
1261: LOOP
1262: x_collect_from := x_collect_from||fnd_global.local_chr(10)||rec.name||',';
1263: END LOOP;
1264: --+
1265: -- Terminate the Collect_From list with the CN_NOT_TRX table
1266: --+

Line 1267: x_collect_from := x_collect_from||fnd_global.local_chr(10)||'cn_not_trx cnt';

1263: END LOOP;
1264: --+
1265: -- Terminate the Collect_From list with the CN_NOT_TRX table
1266: --+
1267: x_collect_from := x_collect_from||fnd_global.local_chr(10)||'cn_not_trx cnt';
1268: --+
1269: -- The Collect_Where clause at a minimun joins the primary_key of the Line
1270: -- table to cnt.Source_Trx_Line_Id
1271: --+

Line 1279: x_collect_where := x_collect_where||fnd_global.local_chr(10)||'AND '||

1275: -- If there is a header table then the Collect_Where is extended to join
1276: -- the primary_key of the Header table to cnt.Source_Trx_Id
1277: --+
1278: IF l_c1_rec.hdr_pk_col IS NOT NULL THEN
1279: x_collect_where := x_collect_where||fnd_global.local_chr(10)||'AND '||
1280: l_c1_rec.hdr_tab_alias||'.'||l_c1_rec.hdr_pk_col||' = cnt.source_trx_id';
1281: END IF;
1282: -------------------+
1283: -- End of API body.