DBA Data[Home] [Help]

APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on FND_GLOBAL

Line 10: l_amp VARCHAR2(8) := fnd_global.local_chr(38);

6: -- --------------------------------------
7:
8: -- cs_newline varchar2(1) := chr(10);
9: cs_delimiter varchar2(1) := ' ';
10: l_amp VARCHAR2(8) := fnd_global.local_chr(38);
11: l_new_line VARCHAR2(8) := fnd_global.newline;
12: dbg_msg VARCHAR2(4000);
13:
14: /****************************************************************************

Line 11: l_new_line VARCHAR2(8) := fnd_global.newline;

7:
8: -- cs_newline varchar2(1) := chr(10);
9: cs_delimiter varchar2(1) := ' ';
10: l_amp VARCHAR2(8) := fnd_global.local_chr(38);
11: l_new_line VARCHAR2(8) := fnd_global.newline;
12: dbg_msg VARCHAR2(4000);
13:
14: /****************************************************************************
15: Forward Declaration

Line 4116: NL VARCHAR2(1) := fnd_global.Local_Chr(10);

4112: l_error_role VARCHAR2(320);
4113:
4114: l_msg_index_OUT NUMBER;
4115: l_error_text VARCHAR2(2000);
4116: NL VARCHAR2(1) := fnd_global.Local_Chr(10);
4117: x_return_status VARCHAR2(1);
4118: x_resource_id NUMBER;
4119: x_resource_type VARCHAR2(50);
4120: x_msg_count NUMBER;

Line 4184: IF (FND_GLOBAL.LOGIN_ID NOT IN (-1,0)) THEN

4180: itemkey => itemkey,
4181: aname => 'OWNER_ROLE' );
4182:
4183:
4184: IF (FND_GLOBAL.LOGIN_ID NOT IN (-1,0)) THEN
4185: l_login_id := FND_GLOBAL.LOGIN_ID;
4186: ELSE
4187: l_login_id := NULL;
4188: END IF;

Line 4185: l_login_id := FND_GLOBAL.LOGIN_ID;

4181: aname => 'OWNER_ROLE' );
4182:
4183:
4184: IF (FND_GLOBAL.LOGIN_ID NOT IN (-1,0)) THEN
4185: l_login_id := FND_GLOBAL.LOGIN_ID;
4186: ELSE
4187: l_login_id := NULL;
4188: END IF;
4189:

Line 5485: NL := fnd_global.Local_Chr(10);

5481:
5482:
5483: BEGIN
5484:
5485: NL := fnd_global.Local_Chr(10);
5486:
5487: IF (funmode = 'RUN') THEN
5488:
5489:

Line 6801: NL := fnd_global.Local_Chr(10);

6797: l_interaction_rec := JTF_IH_PUB.INIT_INTERACTION_REC;
6798: l_activity_rec := JTF_IH_PUB.INIT_ACTIVITY_REC;
6799:
6800: l_int_profile := FND_PROFILE.Value('CS_SR_INTERACTION_LOGGING');
6801: NL := fnd_global.Local_Chr(10);
6802:
6803: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6804:
6805:

Line 6847: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */

6843: l_default_int_reason;
6844: close wrap_cur;
6845:
6846: /* Roopa - Begin - Fix for bug 3360069 */
6847: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */
6848: /* It's necessary to hard code the value of d_resp_appl_id to 170 since
6849: WF item attr RESP_APPL_ID has returned a null value and create and close
6850: interaction calls will fail if we pass a null value for resp_appl_id/handler_id */
6851: IF(d_resp_appl_id is NULL or d_resp_appl_id = -1) THEN

Line 6856: d_resp_id := FND_GLOBAL.RESP_ID;

6852: d_resp_appl_id := 170;
6853: END IF;
6854:
6855: IF(d_resp_id is NULL) THEN
6856: d_resp_id := FND_GLOBAL.RESP_ID;
6857: END IF;
6858:
6859: IF(d_user_id is NULL) THEN
6860: d_user_id := FND_GLOBAL.USER_ID;

Line 6860: d_user_id := FND_GLOBAL.USER_ID;

6856: d_resp_id := FND_GLOBAL.RESP_ID;
6857: END IF;
6858:
6859: IF(d_user_id is NULL) THEN
6860: d_user_id := FND_GLOBAL.USER_ID;
6861: END IF;
6862:
6863: IF(d_login_id is NULL) THEN
6864: d_login_id := FND_GLOBAL.LOGIN_ID;

Line 6864: d_login_id := FND_GLOBAL.LOGIN_ID;

6860: d_user_id := FND_GLOBAL.USER_ID;
6861: END IF;
6862:
6863: IF(d_login_id is NULL) THEN
6864: d_login_id := FND_GLOBAL.LOGIN_ID;
6865: END IF;
6866: /* Roopa - End - Fix for bug 3360069 */
6867:
6868: l_interaction_rec.party_id := p_party_id;

Line 7007: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */

7003:
7004: END IF; -- IF (l_act_wrapup_id is not null)
7005:
7006: /* Roopa - Begin - Fix for bug 3360069 */
7007: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */
7008: IF(d_resp_appl_id is NULL or d_resp_appl_id = -1) THEN
7009: d_resp_appl_id := 170;
7010: END IF;
7011:

Line 7013: d_resp_id := FND_GLOBAL.RESP_ID;

7009: d_resp_appl_id := 170;
7010: END IF;
7011:
7012: IF(d_resp_id is NULL) THEN
7013: d_resp_id := FND_GLOBAL.RESP_ID;
7014: END IF;
7015:
7016: IF(d_user_id is NULL) THEN
7017: d_user_id := FND_GLOBAL.USER_ID;

Line 7017: d_user_id := FND_GLOBAL.USER_ID;

7013: d_resp_id := FND_GLOBAL.RESP_ID;
7014: END IF;
7015:
7016: IF(d_user_id is NULL) THEN
7017: d_user_id := FND_GLOBAL.USER_ID;
7018: END IF;
7019:
7020: IF(d_login_id is NULL) THEN
7021: d_login_id := FND_GLOBAL.LOGIN_ID;

Line 7021: d_login_id := FND_GLOBAL.LOGIN_ID;

7017: d_user_id := FND_GLOBAL.USER_ID;
7018: END IF;
7019:
7020: IF(d_login_id is NULL) THEN
7021: d_login_id := FND_GLOBAL.LOGIN_ID;
7022: END IF;
7023: /* Roopa - End - Fix for bug 3360069 */
7024:
7025: