DBA Data[Home] [Help]

APPS.EDW_SOURCE_INST_PKG dependencies on BIS_UTILITIES_PUB

Line 31: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

27: Procedure Translate_edw_source_instances
28: ( p_api_version IN NUMBER
29: , p_commit IN VARCHAR2 := FND_API.G_FALSE
30: , p_src_inst_rec IN EDW_SOURCE_INST_PKG.src_inst_rec_type
31: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
32: , x_return_status OUT VARCHAR2
33: )
34: IS
35: l_user_id NUMBER;

Line 39: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

35: l_user_id NUMBER;
36: l_login_id NUMBER;
37:
38: BEGIN
39: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
40: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
41: ELSE
42: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
43: END IF;

Line 40: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

36: l_login_id NUMBER;
37:
38: BEGIN
39: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
40: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
41: ELSE
42: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
43: END IF;
44:

Line 42: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;

38: BEGIN
39: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
40: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
41: ELSE
42: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
43: END IF;
44:
45: l_login_id := fnd_global.LOGIN_ID;
46:

Line 75: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

71: Procedure Load_Edw_source_instances
72: ( p_api_version IN NUMBER
73: , p_commit IN VARCHAR2 := FND_API.G_FALSE
74: , p_src_inst_rec IN EDW_SOURCE_INST_PKG.src_inst_rec_type
75: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
76: , x_return_status OUT VARCHAR2)
77: IS
78: l_user_id NUMBER;
79: l_login_id NUMBER;

Line 83: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

79: l_login_id NUMBER;
80:
81: BEGIN
82:
83: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
84: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
85: ELSE
86: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
87: END IF;

Line 84: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

80:
81: BEGIN
82:
83: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
84: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
85: ELSE
86: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
87: END IF;
88:

Line 86: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;

82:
83: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
84: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
85: ELSE
86: l_user_id := BIS_UTILITIES_PUB.G_CUSTOM_USER_ID;
87: END IF;
88:
89: l_login_id := fnd_global.LOGIN_ID;
90: