DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_WORK_PUB

Line 1307: l_strategy_mailer_rec OUT NOCOPY iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type) IS

1303: --- populate strategy mailer record type
1304: PROCEDURE populate_strategy_mailer
1305: (itemtype IN VARCHAR2,
1306: itemkey IN VARCHAR2,
1307: l_strategy_mailer_rec OUT NOCOPY iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type) IS
1308: BEGIN
1309: -- IF PG_DEBUG < 10 THEN
1310: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1311: iex_debug_pub.logmessage ('**** BEGIN populate_strategy_mailer ************');

Line 2581: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;

2577: l_work_item_temp_id NUMBER;
2578: l_result VARCHAR2(1);
2579: l_fulfil_temp_id NUMBER;
2580: l_value VARCHAr2(300);
2581: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;
2582: l_return_status VARCHAR2(1) ;
2583: l_msg_count NUMBER;
2584: l_msg_data VARCHAR2(32767);
2585: l_curr_dmethod varchar2(10);

Line 2643: iex_strategy_work_pub.strategy_mailer(

2639: -- IF PG_DEBUG < 10 THEN
2640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2641: iex_debug_pub.logmessage('FULFIL_CHECK: ' || 'fulful template id' ||l_fulfil_temp_id);
2642: END IF;
2643: iex_strategy_work_pub.strategy_mailer(
2644: p_api_version =>1.0,
2645: p_init_msg_list => FND_API.G_FALSE,
2646: p_commit => FND_API.G_TRUE,
2647: p_strategy_mailer_rec => l_strategy_mailer_rec,

Line 2698: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;

2694:
2695: l_result VARCHAR2(1);
2696: l_fulfil_temp_id NUMBER;
2697: l_value VARCHAr2(300);
2698: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;
2699: l_return_status VARCHAR2(1) ;
2700: l_msg_count NUMBER;
2701: l_msg_data VARCHAR2(32767);
2702: l_execution_time date;