49: p_init_msg_list=>'F' ,
50: p_commit=>'F' ,
51: p_request_id =>l_seq_id,
52: p_source_message_id =>p_message_id,
53: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
54: p_CREATION_DATE =>sysdate,
55: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
56: p_LAST_UPDATE_DATE =>sysdate,
57: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
51: p_request_id =>l_seq_id,
52: p_source_message_id =>p_message_id,
53: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
54: p_CREATION_DATE =>sysdate,
55: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
56: p_LAST_UPDATE_DATE =>sysdate,
57: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
58: x_return_status=>l_ret_status,
59: x_msg_count=>l_msg_count,
53: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
54: p_CREATION_DATE =>sysdate,
55: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
56: p_LAST_UPDATE_DATE =>sysdate,
57: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
58: x_return_status=>l_ret_status,
59: x_msg_count=>l_msg_count,
60: x_msg_data=>l_msg_data
61: );
74: p_folder_name=>p_folder ,
75: p_arch_folder_id=>l_arch_folder_id,
76: p_arch_count=>l_arch_count,
77: p_request=>p_request_type,
78: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
79: p_CREATION_DATE =>sysdate,
80: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
81: p_LAST_UPDATE_DATE =>sysdate,
82: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
76: p_arch_count=>l_arch_count,
77: p_request=>p_request_type,
78: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
79: p_CREATION_DATE =>sysdate,
80: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
81: p_LAST_UPDATE_DATE =>sysdate,
82: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
83: x_return_status=>l_ret_status,
84: x_msg_count=>l_msg_count,
78: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
79: p_CREATION_DATE =>sysdate,
80: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
81: p_LAST_UPDATE_DATE =>sysdate,
82: p_LAST_UPDATE_LOGIN =>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')),
83: x_return_status=>l_ret_status,
84: x_msg_count=>l_msg_count,
85: x_msg_data=>l_msg_data
86: );
483:
484: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
485: 'T',
486: 'F',
487: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
488: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
489: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
490: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
491: l_ret_status,
484: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
485: 'T',
486: 'F',
487: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
488: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
489: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
490: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
491: l_ret_status,
492: l_msg_count,
485: 'T',
486: 'F',
487: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
488: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
489: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
490: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
491: l_ret_status,
492: l_msg_count,
493: l_msg_data,
486: 'F',
487: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
488: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
489: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
490: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
491: l_ret_status,
492: l_msg_count,
493: l_msg_data,
494: l_media_lc_rec,
509: l_media_lc_rec.milcs_id:=l_milcs_id;
510: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
511: 'T',
512: 'F',
513: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
514: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
515: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
516: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
517: l_ret_status,
510: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
511: 'T',
512: 'F',
513: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
514: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
515: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
516: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
517: l_ret_status,
518: l_msg_count,
511: 'T',
512: 'F',
513: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
514: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
515: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
516: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
517: l_ret_status,
518: l_msg_count,
519: l_msg_data,
512: 'F',
513: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
514: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
515: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
516: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
517: l_ret_status,
518: l_msg_count,
519: l_msg_data,
520: l_media_lc_rec);