eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PVT dependencies on MO_GLOBAL

Line 2757: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

2753: ----------------------
2754: ---Overload procedure for bug5548778
2755: Procedure Create_Hold_Source (
2756: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2757: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2758: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
2759: x_hold_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2760: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2761: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2774: l_org_id := MO_GLOBAL.get_current_org_id;

2770: BEGIN
2771: x_return_status := FND_API.G_RET_STS_SUCCESS;
2772: x_hold_exists := 'N';
2773: l_user_id := OE_HOLDS_PVT.get_user_id;
2774: l_org_id := MO_GLOBAL.get_current_org_id;
2775: IF l_org_id IS NULL THEN
2776: -- org_id is null, raise an error.
2777: oe_debug_pub.add('Org_Id is NULL',1);
2778: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3000: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

2996:
2997: ------
2998: Procedure Create_Hold_Source (
2999: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
3000: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
3001: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
3002: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3003: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3004: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 3016: l_org_id := MO_GLOBAL.get_current_org_id;

3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
3013: BEGIN
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;
3015: l_user_id := OE_HOLDS_PVT.get_user_id;
3016: l_org_id := MO_GLOBAL.get_current_org_id;
3017: IF l_org_id IS NULL THEN
3018: -- org_id is null, raise an error.
3019: oe_debug_pub.add('Org_Id is NULL',1);
3020: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3276: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

3272:
3273: ---------------------
3274: Procedure Create_Order_Holds(
3275: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
3276: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
3277: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3278: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3279: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3280: IS

Line 3346: l_org_id := MO_GLOBAL.get_current_org_id;

3342: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3343: BEGIN
3344: x_return_status := FND_API.G_RET_STS_SUCCESS;
3345: l_user_id := OE_HOLDS_PVT.get_user_id;
3346: l_org_id := MO_GLOBAL.get_current_org_id;
3347: IF l_org_id IS NULL THEN
3348: -- org_id is null, raise an error.
3349: oe_debug_pub.add('Org_Id is NULL',1);
3350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6778: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

6774: l_prev_org_id := null;
6775: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6776: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6777: THEN
6778: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6779: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6780: p_org_id => p_sel_rec_tbl(j).Org_Id);
6781: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6782: END IF;

Line 6779: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

6775: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6776: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6777: THEN
6778: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6779: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6780: p_org_id => p_sel_rec_tbl(j).Org_Id);
6781: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6782: END IF;
6783:

Line 7030: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

7026: ', l_prev_org_id:' || l_prev_org_id);
7027:
7028: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7029: THEN
7030: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7031: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7032: p_org_id => p_sel_rec_tbl(j).Org_Id);
7033: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
7034: l_prev_org_id := p_sel_rec_tbl(j).org_id;

Line 7031: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

7027:
7028: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7029: THEN
7030: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7031: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7032: p_org_id => p_sel_rec_tbl(j).Org_Id);
7033: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
7034: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7035: END IF;

Line 7033: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);

7029: THEN
7030: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7031: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7032: p_org_id => p_sel_rec_tbl(j).Org_Id);
7033: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
7034: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7035: END IF;
7036:
7037: l_hold_source_rec.hold_entity_code := 'O';

Line 7265: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

7261: l_prev_org_id := null;
7262: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7263: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7264: THEN
7265: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7266: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7267: p_org_id => p_sel_rec_tbl(j).Org_Id);
7268: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7269: END IF;

Line 7266: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

7262: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7263: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7264: THEN
7265: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7266: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7267: p_org_id => p_sel_rec_tbl(j).Org_Id);
7268: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7269: END IF;
7270:

Line 7445: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

7441: l_prev_org_id := null;
7442: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7443: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7444: THEN
7445: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7446: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7447: p_org_id => p_sel_rec_tbl(j).Org_Id);
7448: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7449: END IF;

Line 7446: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

7442: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7443: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
7444: THEN
7445: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7446: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7447: p_org_id => p_sel_rec_tbl(j).Org_Id);
7448: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7449: END IF;
7450: l_order_tbl(1).header_id := p_sel_rec_tbl(j).Id1;

Line 7534: ,p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id --ER#7479609

7530: procedure process_create_source(
7531: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
7532: ,p_hold_existing_flg IN varchar2
7533: ,p_hold_future_flg IN varchar2
7534: ,p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id --ER#7479609
7535: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7536: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7537: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7538: )

Line 8048: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

8044: l_prev_org_id := null;
8045: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
8046: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
8047: THEN
8048: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
8049: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
8050: p_org_id => p_sel_rec_tbl(j).Org_Id);
8051: l_prev_org_id := p_sel_rec_tbl(j).org_id;
8052: END IF;

Line 8049: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

8045: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
8046: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
8047: THEN
8048: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
8049: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
8050: p_org_id => p_sel_rec_tbl(j).Org_Id);
8051: l_prev_org_id := p_sel_rec_tbl(j).org_id;
8052: END IF;
8053:

Line 8260: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );

8256:
8257: l_prev_org_id := null;
8258: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
8259: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99) THEN
8260: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
8261: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
8262: p_org_id => p_sel_rec_tbl(j).Org_Id);
8263: l_prev_org_id := p_sel_rec_tbl(j).org_id;
8264: END IF;

Line 8261: Mo_Global.Set_Policy_Context (p_access_mode => 'S',

8257: l_prev_org_id := null;
8258: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
8259: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99) THEN
8260: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
8261: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
8262: p_org_id => p_sel_rec_tbl(j).Org_Id);
8263: l_prev_org_id := p_sel_rec_tbl(j).org_id;
8264: END IF;
8265: l_order_tbl(1).header_id := p_sel_rec_tbl(j).Id1;

Line 8715: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

8711: Procedure Apply_Holds(
8712: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
8713: p_hold_existing_flg IN VARCHAR2,
8714: p_hold_future_flg IN VARCHAR2,
8715: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
8716: p_wf_item_type IN VARCHAR2 DEFAULT NULL,
8717: p_wf_activity_name IN VARCHAR2 DEFAULT NULL,
8718: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', --bug 8477694
8719: x_return_status OUT NOCOPY VARCHAR2,

Line 8888: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

8884:
8885: /*Added New Overloaded Procedure Create_Order_hols for WF_HOLDS ER (bug 6449458)*/
8886: Procedure Create_Order_Holds(
8887: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
8888: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
8889: p_item_type IN VARCHAR2,
8890: p_activity_name IN VARCHAR2,
8891: x_return_status OUT NOCOPY VARCHAR2,
8892: x_msg_count OUT NOCOPY NUMBER,

Line 9027: l_org_id := MO_GLOBAL.get_current_org_id;

9023: l_master_orgid VARCHAR2(10) := oe_sys_parameters.Value('MASTER_ORGANIZATION_ID'); --13653352
9024: BEGIN
9025: x_return_status := FND_API.G_RET_STS_SUCCESS;
9026: l_user_id := OE_HOLDS_PVT.get_user_id;
9027: l_org_id := MO_GLOBAL.get_current_org_id;
9028: x_is_hold_applied := NULL;
9029: IF l_org_id IS NULL THEN
9030: -- org_id is null, raise an error.
9031: oe_debug_pub.add('Org_Id is NULL',1);