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 4178: NL VARCHAR2(1) := fnd_global.Local_Chr(10);

4174: l_error_role VARCHAR2(320);
4175:
4176: l_msg_index_OUT NUMBER;
4177: l_error_text VARCHAR2(2000);
4178: NL VARCHAR2(1) := fnd_global.Local_Chr(10);
4179: x_return_status VARCHAR2(1);
4180: x_resource_id NUMBER;
4181: x_resource_type VARCHAR2(50);
4182: x_msg_count NUMBER;

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

4242: itemkey => itemkey,
4243: aname => 'OWNER_ROLE' );
4244:
4245:
4246: IF (FND_GLOBAL.LOGIN_ID NOT IN (-1,0)) THEN
4247: l_login_id := FND_GLOBAL.LOGIN_ID;
4248: ELSE
4249: l_login_id := NULL;
4250: END IF;

Line 4247: l_login_id := FND_GLOBAL.LOGIN_ID;

4243: aname => 'OWNER_ROLE' );
4244:
4245:
4246: IF (FND_GLOBAL.LOGIN_ID NOT IN (-1,0)) THEN
4247: l_login_id := FND_GLOBAL.LOGIN_ID;
4248: ELSE
4249: l_login_id := NULL;
4250: END IF;
4251:

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

5545:
5546:
5547: BEGIN
5548:
5549: NL := fnd_global.Local_Chr(10);
5550:
5551: IF (funmode = 'RUN') THEN
5552:
5553:

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

6861: l_interaction_rec := JTF_IH_PUB.INIT_INTERACTION_REC;
6862: l_activity_rec := JTF_IH_PUB.INIT_ACTIVITY_REC;
6863:
6864: l_int_profile := FND_PROFILE.Value('CS_SR_INTERACTION_LOGGING');
6865: NL := fnd_global.Local_Chr(10);
6866:
6867: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6868:
6869:

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

6907: l_default_int_reason;
6908: close wrap_cur;
6909:
6910: /* Roopa - Begin - Fix for bug 3360069 */
6911: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */
6912: /* It's necessary to hard code the value of d_resp_appl_id to 170 since
6913: WF item attr RESP_APPL_ID has returned a null value and create and close
6914: interaction calls will fail if we pass a null value for resp_appl_id/handler_id */
6915: IF(d_resp_appl_id is NULL or d_resp_appl_id = -1) THEN

Line 6920: d_resp_id := FND_GLOBAL.RESP_ID;

6916: d_resp_appl_id := 170;
6917: END IF;
6918:
6919: IF(d_resp_id is NULL) THEN
6920: d_resp_id := FND_GLOBAL.RESP_ID;
6921: END IF;
6922:
6923: IF(d_user_id is NULL) THEN
6924: d_user_id := FND_GLOBAL.USER_ID;

Line 6924: d_user_id := FND_GLOBAL.USER_ID;

6920: d_resp_id := FND_GLOBAL.RESP_ID;
6921: END IF;
6922:
6923: IF(d_user_id is NULL) THEN
6924: d_user_id := FND_GLOBAL.USER_ID;
6925: END IF;
6926:
6927: IF(d_login_id is NULL) THEN
6928: d_login_id := FND_GLOBAL.LOGIN_ID;

Line 6928: d_login_id := FND_GLOBAL.LOGIN_ID;

6924: d_user_id := FND_GLOBAL.USER_ID;
6925: END IF;
6926:
6927: IF(d_login_id is NULL) THEN
6928: d_login_id := FND_GLOBAL.LOGIN_ID;
6929: END IF;
6930: /* Roopa - End - Fix for bug 3360069 */
6931:
6932: l_interaction_rec.party_id := p_party_id;

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

7067:
7068: END IF; -- IF (l_act_wrapup_id is not null)
7069:
7070: /* Roopa - Begin - Fix for bug 3360069 */
7071: /* Initializing the local vars with FND_GLOBAL values if the local vars are null in value */
7072: IF(d_resp_appl_id is NULL or d_resp_appl_id = -1) THEN
7073: d_resp_appl_id := 170;
7074: END IF;
7075:

Line 7077: d_resp_id := FND_GLOBAL.RESP_ID;

7073: d_resp_appl_id := 170;
7074: END IF;
7075:
7076: IF(d_resp_id is NULL) THEN
7077: d_resp_id := FND_GLOBAL.RESP_ID;
7078: END IF;
7079:
7080: IF(d_user_id is NULL) THEN
7081: d_user_id := FND_GLOBAL.USER_ID;

Line 7081: d_user_id := FND_GLOBAL.USER_ID;

7077: d_resp_id := FND_GLOBAL.RESP_ID;
7078: END IF;
7079:
7080: IF(d_user_id is NULL) THEN
7081: d_user_id := FND_GLOBAL.USER_ID;
7082: END IF;
7083:
7084: IF(d_login_id is NULL) THEN
7085: d_login_id := FND_GLOBAL.LOGIN_ID;

Line 7085: d_login_id := FND_GLOBAL.LOGIN_ID;

7081: d_user_id := FND_GLOBAL.USER_ID;
7082: END IF;
7083:
7084: IF(d_login_id is NULL) THEN
7085: d_login_id := FND_GLOBAL.LOGIN_ID;
7086: END IF;
7087: /* Roopa - End - Fix for bug 3360069 */
7088:
7089: