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.29 2011/10/19 20:43:07 hgeorgi 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: SUBTYPE noview_value_type IS fnd_flex_values%ROWTYPE;

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

3020: -- ---------------------------------------------------------------------------
3021: PROCEDURE set_who(px_who IN OUT nocopy fnd_flex_loader_apis.who_type)
3022: IS
3023: BEGIN
3024: px_who.created_by := fnd_global.user_id();
3025: px_who.creation_date := Sysdate;
3026: px_who.last_updated_by := fnd_global.user_id();
3027: px_who.last_update_date := Sysdate;
3028: px_who.last_update_login := fnd_global.login_id();

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

3022: IS
3023: BEGIN
3024: px_who.created_by := fnd_global.user_id();
3025: px_who.creation_date := Sysdate;
3026: px_who.last_updated_by := fnd_global.user_id();
3027: px_who.last_update_date := Sysdate;
3028: px_who.last_update_login := fnd_global.login_id();
3029: EXCEPTION
3030: WHEN OTHERS THEN

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

3024: px_who.created_by := fnd_global.user_id();
3025: px_who.creation_date := Sysdate;
3026: px_who.last_updated_by := fnd_global.user_id();
3027: px_who.last_update_date := Sysdate;
3028: px_who.last_update_login := fnd_global.login_id();
3029: EXCEPTION
3030: WHEN OTHERS THEN
3031: raise_error(ERROR_UNABLE_TO_SET_WHO,
3032: 'Unable to set WHO Information.');

Line 4879: NEWLINE := fnd_global.newline;

4875: WHITESPACE VARCHAR2(1);
4876:
4877: BEGIN
4878:
4879: NEWLINE := fnd_global.newline;
4880: TAB := fnd_global.tab;
4881: WHITESPACE := ' ';
4882:
4883: if(p_sql_clause is not NULL) then

Line 4880: TAB := fnd_global.tab;

4876:
4877: BEGIN
4878:
4879: NEWLINE := fnd_global.newline;
4880: TAB := fnd_global.tab;
4881: WHITESPACE := ' ';
4882:
4883: if(p_sql_clause is not NULL) then
4884:

Line 5007: NEWLINE := fnd_global.newline;

5003: l_name_string := 'NAME=';
5004: l_open_bracket := '(';
5005: l_close_bracket := ')';
5006: l_starting_position := 1;
5007: NEWLINE := fnd_global.newline;
5008: WHITESPACE := fnd_global.local_chr(32);
5009: l_into(0) := WHITESPACE||'into'||WHITESPACE;
5010: l_into(1) := WHITESPACE||'into'||NEWLINE;
5011: l_into(2) := NEWLINE||'into'||WHITESPACE;

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

5004: l_open_bracket := '(';
5005: l_close_bracket := ')';
5006: l_starting_position := 1;
5007: NEWLINE := fnd_global.newline;
5008: WHITESPACE := fnd_global.local_chr(32);
5009: l_into(0) := WHITESPACE||'into'||WHITESPACE;
5010: l_into(1) := WHITESPACE||'into'||NEWLINE;
5011: l_into(2) := NEWLINE||'into'||WHITESPACE;
5012: l_into(3) := NEWLINE||'into'||NEWLINE;