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 2302: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609

2298: ----------------------
2299: ---Overload procedure for bug5548778
2300: Procedure Create_Hold_Source (
2301: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2302: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2303: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
2304: x_hold_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2305: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2306: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2319: l_org_id := MO_GLOBAL.get_current_org_id;

2315: BEGIN
2316: x_return_status := FND_API.G_RET_STS_SUCCESS;
2317: x_hold_exists := 'N';
2318: l_user_id := OE_HOLDS_PVT.get_user_id;
2319: l_org_id := MO_GLOBAL.get_current_org_id;
2320: IF l_org_id IS NULL THEN
2321: -- org_id is null, raise an error.
2322: oe_debug_pub.add('Org_Id is NULL',1);
2323: x_return_status := FND_API.G_RET_STS_ERROR;

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

2541:
2542: ------
2543: Procedure Create_Hold_Source (
2544: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2545: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2546: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
2547: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2548: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2549: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2561: l_org_id := MO_GLOBAL.get_current_org_id;

2557: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
2558: BEGIN
2559: x_return_status := FND_API.G_RET_STS_SUCCESS;
2560: l_user_id := OE_HOLDS_PVT.get_user_id;
2561: l_org_id := MO_GLOBAL.get_current_org_id;
2562: IF l_org_id IS NULL THEN
2563: -- org_id is null, raise an error.
2564: oe_debug_pub.add('Org_Id is NULL',1);
2565: x_return_status := FND_API.G_RET_STS_ERROR;

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

2817:
2818: ---------------------
2819: Procedure Create_Order_Holds(
2820: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2821: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2822: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2823: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2824: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2825: IS

Line 2891: l_org_id := MO_GLOBAL.get_current_org_id;

2887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2888: BEGIN
2889: x_return_status := FND_API.G_RET_STS_SUCCESS;
2890: l_user_id := OE_HOLDS_PVT.get_user_id;
2891: l_org_id := MO_GLOBAL.get_current_org_id;
2892: IF l_org_id IS NULL THEN
2893: -- org_id is null, raise an error.
2894: oe_debug_pub.add('Org_Id is NULL',1);
2895: x_return_status := FND_API.G_RET_STS_ERROR;

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

6018: l_prev_org_id := null;
6019: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6020: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6021: THEN
6022: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6023: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6024: p_org_id => p_sel_rec_tbl(j).Org_Id);
6025: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6026: END IF;

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

6019: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6020: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6021: THEN
6022: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6023: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6024: p_org_id => p_sel_rec_tbl(j).Org_Id);
6025: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6026: END IF;
6027:

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

6269: ', l_prev_org_id:' || l_prev_org_id);
6270:
6271: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6272: THEN
6273: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6274: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6275: p_org_id => p_sel_rec_tbl(j).Org_Id);
6276: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
6277: l_prev_org_id := p_sel_rec_tbl(j).org_id;

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

6270:
6271: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6272: THEN
6273: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6274: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6275: p_org_id => p_sel_rec_tbl(j).Org_Id);
6276: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
6277: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6278: END IF;

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

6272: THEN
6273: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6274: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6275: p_org_id => p_sel_rec_tbl(j).Org_Id);
6276: OE_DEBUG_PUB.Add('After the ORG is :' || MO_GLOBAL.get_current_org_id);
6277: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6278: END IF;
6279:
6280: l_hold_source_rec.hold_entity_code := 'O';

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

6503: l_prev_org_id := null;
6504: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6505: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6506: THEN
6507: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6508: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6509: p_org_id => p_sel_rec_tbl(j).Org_Id);
6510: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6511: END IF;

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

6504: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6505: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6506: THEN
6507: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6508: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6509: p_org_id => p_sel_rec_tbl(j).Org_Id);
6510: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6511: END IF;
6512:

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

6682: l_prev_org_id := null;
6683: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6684: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6685: THEN
6686: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6687: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6688: p_org_id => p_sel_rec_tbl(j).Org_Id);
6689: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6690: END IF;

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

6683: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
6684: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99)
6685: THEN
6686: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
6687: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
6688: p_org_id => p_sel_rec_tbl(j).Org_Id);
6689: l_prev_org_id := p_sel_rec_tbl(j).org_id;
6690: END IF;
6691: l_order_tbl(1).header_id := p_sel_rec_tbl(j).Id1;

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

6770: procedure process_create_source(
6771: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type
6772: ,p_hold_existing_flg IN varchar2
6773: ,p_hold_future_flg IN varchar2
6774: ,p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id --ER#7479609
6775: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6776: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
6777: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6778: )

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

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

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

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

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

7471:
7472: l_prev_org_id := null;
7473: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7474: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99) THEN
7475: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7476: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7477: p_org_id => p_sel_rec_tbl(j).Org_Id);
7478: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7479: END IF;

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

7472: l_prev_org_id := null;
7473: FOR j in 1.. p_sel_rec_tbl.COUNT LOOP
7474: IF p_sel_rec_tbl(j).org_id <> nvl(l_prev_org_id, -99) THEN
7475: OE_DEBUG_PUB.Add('Mo_Global.Set_Policy_Context to:' || p_sel_rec_tbl(j).Org_Id );
7476: Mo_Global.Set_Policy_Context (p_access_mode => 'S',
7477: p_org_id => p_sel_rec_tbl(j).Org_Id);
7478: l_prev_org_id := p_sel_rec_tbl(j).org_id;
7479: END IF;
7480: l_order_tbl(1).header_id := p_sel_rec_tbl(j).Id1;

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

7924: Procedure Apply_Holds(
7925: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
7926: p_hold_existing_flg IN VARCHAR2,
7927: p_hold_future_flg IN VARCHAR2,
7928: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
7929: p_wf_item_type IN VARCHAR2 DEFAULT NULL,
7930: p_wf_activity_name IN VARCHAR2 DEFAULT NULL,
7931: x_return_status OUT NOCOPY VARCHAR2,
7932: x_msg_count OUT NOCOPY NUMBER,

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

8028:
8029: /*Added New Overloaded Procedure Create_Order_hols for WF_HOLDS ER (bug 6449458)*/
8030: Procedure Create_Order_Holds(
8031: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
8032: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
8033: p_item_type IN VARCHAR2,
8034: p_activity_name IN VARCHAR2,
8035: x_return_status OUT NOCOPY VARCHAR2,
8036: x_msg_count OUT NOCOPY NUMBER,

Line 8164: l_org_id := MO_GLOBAL.get_current_org_id;

8160: -- GENESIS --
8161: BEGIN
8162: x_return_status := FND_API.G_RET_STS_SUCCESS;
8163: l_user_id := OE_HOLDS_PVT.get_user_id;
8164: l_org_id := MO_GLOBAL.get_current_org_id;
8165: x_is_hold_applied := NULL;
8166: IF l_org_id IS NULL THEN
8167: -- org_id is null, raise an error.
8168: oe_debug_pub.add('Org_Id is NULL',1);