DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WF dependencies on IEX_STRATEGY_WORK_PUB

Line 1471: l_strategy_mailer_rec OUT NOCOPY iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type) IS

1467: --- populate strategy mailer record type
1468: PROCEDURE populate_strategy_mailer
1469: (itemtype IN VARCHAR2,
1470: itemkey IN VARCHAR2,
1471: l_strategy_mailer_rec OUT NOCOPY iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type) IS
1472: BEGIN
1473: -- IF PG_DEBUG < 10 THEN
1474: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1475: iex_debug_pub.logmessage ('**** BEGIN populate_strategy_mailer ************');

Line 2773: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;

2769: l_work_item_temp_id NUMBER;
2770: l_result VARCHAR2(1);
2771: l_fulfil_temp_id NUMBER;
2772: l_value VARCHAr2(300);
2773: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;
2774: l_return_status VARCHAR2(1) ;
2775: l_msg_count NUMBER;
2776: l_msg_data VARCHAR2(32767);
2777: l_curr_dmethod varchar2(10);

Line 2861: iex_strategy_work_pub.strategy_mailer(

2857: -- IF PG_DEBUG < 10 THEN
2858: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2859: iex_debug_pub.logmessage('FULFIL_CHECK: ' || 'fulful template id' ||l_fulfil_temp_id);
2860: END IF;
2861: iex_strategy_work_pub.strategy_mailer(
2862: p_api_version =>1.0,
2863: p_init_msg_list => FND_API.G_FALSE,
2864: p_commit => FND_API.G_TRUE,
2865: p_strategy_mailer_rec => l_strategy_mailer_rec,

Line 2916: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;

2912:
2913: l_result VARCHAR2(1);
2914: l_fulfil_temp_id NUMBER;
2915: l_value VARCHAr2(300);
2916: l_strategy_mailer_rec iex_strategy_work_pub.STRATEGY_Mailer_Rec_Type;
2917: l_return_status VARCHAR2(1) ;
2918: l_msg_count NUMBER;
2919: l_msg_data VARCHAR2(32767);
2920: l_execution_time date;