DBA Data[Home] [Help]

APPS.FND_FLEX_VAL_API dependencies on FND_GLOBAL

Line 5: chr_newline CONSTANT VARCHAR2(8) := fnd_global.newline;

1: PACKAGE BODY fnd_flex_val_api AS
2: /* $Header: AFFFVAIB.pls 120.25.12010000.1 2008/07/25 14:14:42 appldev ship $ */
3:
4:
5: chr_newline CONSTANT VARCHAR2(8) := fnd_global.newline;
6:
7: SUBTYPE vset_type IS fnd_flex_value_sets%ROWTYPE;
8: SUBTYPE value_type IS fnd_flex_values_vl%ROWTYPE;
9:

Line 2896: px_who.created_by := fnd_global.user_id();

2892: -- ---------------------------------------------------------------------------
2893: PROCEDURE set_who(px_who IN OUT nocopy fnd_flex_loader_apis.who_type)
2894: IS
2895: BEGIN
2896: px_who.created_by := fnd_global.user_id();
2897: px_who.creation_date := Sysdate;
2898: px_who.last_updated_by := fnd_global.user_id();
2899: px_who.last_update_date := Sysdate;
2900: px_who.last_update_login := fnd_global.login_id();

Line 2898: px_who.last_updated_by := fnd_global.user_id();

2894: IS
2895: BEGIN
2896: px_who.created_by := fnd_global.user_id();
2897: px_who.creation_date := Sysdate;
2898: px_who.last_updated_by := fnd_global.user_id();
2899: px_who.last_update_date := Sysdate;
2900: px_who.last_update_login := fnd_global.login_id();
2901: EXCEPTION
2902: WHEN OTHERS THEN

Line 2900: px_who.last_update_login := fnd_global.login_id();

2896: px_who.created_by := fnd_global.user_id();
2897: px_who.creation_date := Sysdate;
2898: px_who.last_updated_by := fnd_global.user_id();
2899: px_who.last_update_date := Sysdate;
2900: px_who.last_update_login := fnd_global.login_id();
2901: EXCEPTION
2902: WHEN OTHERS THEN
2903: raise_error(ERROR_UNABLE_TO_SET_WHO,
2904: 'Unable to set WHO Information.');

Line 4751: NEWLINE := fnd_global.newline;

4747: WHITESPACE VARCHAR2(1);
4748:
4749: BEGIN
4750:
4751: NEWLINE := fnd_global.newline;
4752: TAB := fnd_global.tab;
4753: WHITESPACE := ' ';
4754:
4755: if(p_sql_clause is not NULL) then

Line 4752: TAB := fnd_global.tab;

4748:
4749: BEGIN
4750:
4751: NEWLINE := fnd_global.newline;
4752: TAB := fnd_global.tab;
4753: WHITESPACE := ' ';
4754:
4755: if(p_sql_clause is not NULL) then
4756:

Line 4879: NEWLINE := fnd_global.newline;

4875: l_name_string := 'NAME=';
4876: l_open_bracket := '(';
4877: l_close_bracket := ')';
4878: l_starting_position := 1;
4879: NEWLINE := fnd_global.newline;
4880: WHITESPACE := fnd_global.local_chr(32);
4881: l_into(0) := WHITESPACE||'into'||WHITESPACE;
4882: l_into(1) := WHITESPACE||'into'||NEWLINE;
4883: l_into(2) := NEWLINE||'into'||WHITESPACE;

Line 4880: WHITESPACE := fnd_global.local_chr(32);

4876: l_open_bracket := '(';
4877: l_close_bracket := ')';
4878: l_starting_position := 1;
4879: NEWLINE := fnd_global.newline;
4880: WHITESPACE := fnd_global.local_chr(32);
4881: l_into(0) := WHITESPACE||'into'||WHITESPACE;
4882: l_into(1) := WHITESPACE||'into'||NEWLINE;
4883: l_into(2) := NEWLINE||'into'||WHITESPACE;
4884: l_into(3) := NEWLINE||'into'||NEWLINE;